While debugging a memory issue, we found that when using sqlalchemy with psycopg, when trying to load a single record using first(), it will load the whole results set into memory. Additionally, in ...
sqlalchemy inspector.has_table is supposed to also detect views: https://docs.sqlalchemy.org/en/20/core/reflection.html#sqlalchemy.engine.reflection.Inspector.has ...