RE: ask for help on best practices when changing table name from uppercase to lowercase

On Tue, 2021-01-05 at 13:09 -0500, Mike Bayer wrote: >    On Tue, Jan 5, 2021, at 9:50 AM, kz...@us.ibm.com wrote: > Thanks...                    >                       >                

Re: ask for help on best practices when changing table name from uppercase to lowercase

On Tue, Jan 5, 2021, at 9:50 AM, kz...@us.ibm.com wrote: > Thanks mike! > > I understand that it should work when querying over SQLAlchemy API. the > missing part of my use case I forgot to provide is, it only uses > Alembic/SQLAlchemy to manage schema changes, while the actual query may comes

Re: ask for help on best practices when changing table name from uppercase to lowercase

Thanks mike! I understand that it should work when querying over SQLAlchemy API. the missing part of my use case I forgot to provide is, it only uses Alembic/SQLAlchemy to manage schema changes, while the actual query may comes from other query engine like a dashboard, a desktop DB client or a

Re: ask for help on best practices when changing table name from uppercase to lowercase

This is the casing convention of the database and SQLAlchemy does not consider the name to be in "uppercase" or "lowercase" (or even "mixed case") but rather "case insensitive", which really means the name is referred towards without any quoting.When no quoting is applied, there is essential