TryCF Gist

trycf-gist-1688124786501-e90cc0e0-5e06-1d95-e29e-023b59e812e9.cfm

<cfscript>
 q = queryNew("id,name","integer,varchar");
    loop list="micha,zac,brad,pothys" item="n" index="i" {
        r = queryAddRow(q);
        querySetCell(q, "id", r, r)
        querySetCell(q, "name", n, r)
    }

dump(q);

q2 = duplicate(q);

loop times=2 {
    queryAddRow(q2);
}

dump(q);
dump(q2);

</cfscript>