sqlalchemy-bot on master
allow CTE to be direct DML targ… Merge "allow CTE to be direct D… (compare)
insp = reflection.Inspector.from_engine(engine)
however that method is deprecated https://docs.sqlalchemy.org/en/14/core/reflection.html?#sqlalchemy.engine.reflection.Inspector.from_engine
I just tried to run some Identity tests, and was hitting a pg9 database by accident. That just gives a generic error:
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.SyntaxError) syntax error at or near "GENERATED"
This could potentially be more clear via docs or code that alerts users "Postgres 10 is needed for Identity Columns"