I'm trying to get the literal query (with the binds inline) for a SQLite connection per the docs: http://docs.sqlalchemy.org/en/latest/faq.html#faq-sql-expression-string
Here is the statement: print(stmt.compile(SQL_ENGINE,compile_kwargs={"literal_binds": True})) I have a statement object, with parameters bound to it (INSERT in this case) but when I print it it I don't see the binds "inline", just the :bind variables printed. I had thought using this compile_kwargs dictionary I would see my string and integer values in the query that was printed. Am I misunderstanding this? In case you are curious why I would need this I'm trying to use SQLAlchemy to write queries to feed to pyodbc for a database that doesn't have a dialect. The database in question is ANSI-99 compliant though so if I could get SQLAlchemy to write my queries for me (with the binds inline) I had hoped to simply execute them against the pyodbc driver. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.