Hello, SqlAchemy automatically specify the table name in front of columns and thus my query parameters are too long and I get the "(cx_Oracle.DatabaseError) ORA-00972" error on Oracle. For example if my table name is "TABLE_NAME_TOO_LONG" and my columns are "id" and "name" a request will look like this:
SELECT "TABLE_NAME_TOO_LONG".id, "TABLE_NAME_TOO_LONG".name FROM "TABLE_NAME_TOO_LONG" where ... I could use alias for select request in order to bypass this issue if I understand well (https://www.tutorialspoint.com/sqlalchemy/sqlalchemy_core_using_aliases.htm). However for an insert I cannot find any solution. Is there a way to set an alias to a table name for an insert ? or remove the table name ? Best regards ;) -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/03d4cb6c-ce89-47ee-bf5d-58d0c162667fn%40googlegroups.com.
