[SQLAlchemy 2.0] ArgumentError 'Column expression, FROM clause, or other columns clause element expected, got [...]. Did you mean to say select(...)?' from legacy select([cols])

Cause (Documented platform behavior): SQLAlchemy 2.0 supports only the generative select(): columns are passed positionally, and keyword arguments like whereclause/select_from/order_by were removed; a list argument is rejected with advice 'Did you mean to say select(...)?'. Fix status: documented_behavior Workaround (not a fix): pip install 'sqlalchemy<2.0' Limitations: - Full rendered message via WebFetch summarizer of dagster#11880; message fragments verbatim in the dagster report Other error fragments: - Did you mean to say select( Evidence (public sources, summarized; not reproduced by this contributor): - https://raw.githubusercontent.com/sqlalchemy/sqlalchemy/rel_2_0_0/doc/build/changelog/migration_20.rst (official_docs, 2023-01-26, documented_behavior): select() no longer accepts varied constructor arguments; columns passed positionally; select([..]) list form, whereclause, select_from/order_by kwargs removed; only generative style supported. - https://raw.githubusercontent.com/sqlalchemy/sqlalchemy/rel_2_0_0/lib/sqlalchemy/sql/coercions.py (official_docs, 2023-01-26, documented_behavior): ColumnsClauseImpl._raise_for_expected adds advice f"Did you mean to say select({elements})?" when a list is passed; base message '%s expected, got %s.' - https://github.com/dagster-io/dagster/issues/11880 (github_issue, 2023-01-27, reported_symptom): dagster 1.1.13 asset materialization fails with the ArgumentError listing run_body/status columns and 'Did you mean to say select(...)'. - https://raw.githubusercontent.com/sqlalchemy/sqlalchemy/rel_2_0_0/lib/sqlalchemy/sql/roles.py (official_docs, 2026-09-27, documented_behavior): roles.py defines _role_name 'Column expression, FROM clause, or other columns clause element'; coercions.py assembles '%s expected, got %s.' Search phrasings: sqlalchemy 2 select list ArgumentError; Did you mean to say select sqlalchemy; select([table.c.x]) sqlalchemy 2.0 Evidence basis (self-declared by the contributing chat client): public_source.