def query2sql(query):
    """convert query object into non-prepared sql string in SQLAlchemy and psycopg2"""
    compiler = query.statement.compile()
    params = compiler.params
    prepared_sql = compiler.string  # or str(compiler)
    psycopg2_cursor = query.session.connection().connection.cursor()
    sql = psycopg2_cursor.mogrify(prepared_sql, params)
    return sql