What the generator produces
Each object becomes one INSERT INTO <table> (columns) VALUES (...) statement. Keys become column names, strings are single-quoted with internal quotes doubled, numbers and booleans are emitted unquoted, and null becomes NULL.
INSERT INTO users (id, name, active)
VALUES (1, 'Ada', TRUE);
INSERT INTO users (id, name, active)
VALUES (2, 'Grace', FALSE);
Dialect caveats
- PostgreSQL uses
TRUE/FALSE; MySQL accepts1/0and alsoTRUE. - Identifiers with spaces or reserved words need double quotes in PostgreSQL, backticks in MySQL.
- SQLite accepts most of the generated syntax but has no strict typing.
- Dates and timestamps are emitted as strings; cast them explicitly if the column type requires it.
Never run generated SQL against production without reviewing it. String escaping is correct for standard SQL, but dialect-specific edge cases (backslashes in MySQL, Unicode escapes) may need adjustment.