Drizzle TeamDT
Drizzle Team•3y ago
Gruntilda

Best way to get raw SQL for a SQLite insert statement (with inline parameters)?

I tried doing this:
class InlineSQLiteSyncDialect extends SQLiteSyncDialect {
  public inlineParams = true;
}
const dialect = new InlineSQLiteSyncDialect();
const statement: SQLiteInsert = ...;
statement.getSQL().toQuery(dialect).sql;

But get an error error: TypeError: escapeName is not a function. Any ideas?

I could us .toSQL() to get the parameterized SQL and the parameters and then have custom logic to combine them but I'm thinking there's a better way.
Was this page helpful?