Hi Scott,

One more thing to add - you can use LABKEY.Query.updateRows() to manipulate multiple tables with insert, update, and delete operations and control whether the whole set of operations is performed in one transaction, or if each separate command is transacted separately.

LABKEY.Query.executeSQL(), like all APIs that currently operate on LabKey SQL, is strictly read-only, since we only support SELECT statements.

Thanks,
Josh