A data pipeline orchestration library for rapid iterative development with automatic cache invalidation allowing users to focus writing their tasks in pandas, polars, sqlalchemy, ibis, and alike.
Our issues with IBM DB2 were caused by using compiler.preparer.quote_identifier instead of compiler.preparer.quote. Unlike quote, quote_identifier doesn't check if a name should get quoted or not. Because in SQLAlchemy all lowercase identifiers are viewed as case insensitive (ref), this resulted in our custom DDL statements interacting incorrectly with SQLAlchemy.
Our issues with IBM DB2 were caused by using
compiler.preparer.quote_identifierinstead ofcompiler.preparer.quote. Unlikequote,quote_identifierdoesn't check if a name should get quoted or not. Because in SQLAlchemy all lowercase identifiers are viewed as case insensitive (ref), this resulted in our custom DDL statements interacting incorrectly with SQLAlchemy.