How to Prevent SQLAlchemy Core from Quoting Name

[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 because the table name within the quotes is not in all caps.

How can I remove the quotes and instead have it render:

    SELECT myschema.mytable.id

    FROM myschema.mytable

Thanks and best regards,

Matthew

[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