A query string for an INSERT.
TableName | Name of table to do insert on. |
DictValue | Dict containing column names / values for insertion. |
Note that for the dicts, you (currently) must put quotes around any values that will go into text columns or receive an error. We may add support in a future release for automatically detecting the column type and quoting values as necessary.
For information regarding exceptions / errors, see
here.
% SqlInsertStatement my_table {desc 'one' notes 'uno'}
INSERT INTO my_table (desc, notes) VALUES ('one', 'uno')