[sqlalchemy] Re: How to Prevent SQLAlchemy Core from Quoting Name

2022-06-17 Thread mkmo...@gmail.com
My apologies, I just saw that I can use the schema key word for this case: t = table('mytable', column('id'), schema='myschema') Best regards, Matthew On Friday, June 17, 2022 at 11:13:44 AM UTC-7 mkmo...@gmail.com wrote: > Using a `.` in a table name will cause the table name to be

[sqlalchemy] How to Prevent SQLAlchemy Core from Quoting Name

2022-06-17 Thread mkmo...@gmail.com
Using a `.` in a table name will cause the table name to be quoted. For example: from sqlalchemy import table, column t = table('myschema.mytable', column('id')) print(select(t.c.id)) Outputs: SELECT "myschema.mytable".id FROM "myschema.mytable" This fails in Oracle