I'm using SQLAlchemy to record the sql executed (using echo=True) so that I can then import that file directly (after a bit of clean-up). Problem is, the file is full of this:
INSERT INTO professors (department_id, id, first_name, last_name,
preferred_name, email_alias, user_id, created_at, updated_at, middle_name)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
So clearly, it's not giving me the final form of the string which I need.
Your questions has two parts to it:
The first part is answered here: SQLAlchemy: print the actual query. In this respect your question is a clear duplicate.
Read also How do I render SQL expressions as strings, possibly with bound parameters inlined? section of the official documentation.
The second part is: How do I make SQLAlchemy's logging configuration (sqlalchemy.engine logger) log queries using the above.
Short answer to the second part is: you cannot without tempering with the source code. See this start line in the repository if you decide to play with it.
