Gruntilda
Gruntilda
PostsComments
DTDrizzle Team
Created by Gruntilda on 9/26/2023 in #help
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;
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.
3 replies