Database location in Ignition

Yes. Commonly statements of the form Insert Into someTable (...) Select ... From otherTable.