{"repo":"ViAchKoN/sqlalchemy-query-manager","free":true,"listed":false,"github":"https://github.com/ViAchKoN/sqlalchemy-query-manager","clone":"git clone https://github.com/ViAchKoN/sqlalchemy-query-manager.git","description":"Stop writing long SQLAlchemy queries. Q filters, eager loading, bulk ops, and async — Django-style.","language":"Python","stars":10,"topics":["async","django-orm","fastapi","flask","orm","orm-framework","python","query-manager","sqlalchemy"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLAlchemy Query Manager Django-style ORM interface for SQLAlchemy — Q filters, eager loading, async support, and zero session boilerplate. Built on top of dataclass-sqlalchemy-mixins. Package requirements - python = 3.8.1 - sqlalchemy = 1.4.0 Installation --- Before / After Before — vanilla SQLAlchemy: After — with sqlalchemy-query-manager : --- Features Filtering - Django-style lookups — where(number gte=100, name ilike=\"test%\") - Q objects — Q(x=1) Q(y=2) , nesting with & and - Auto-join on FK filters — where(group is active=True) joins automatically Eager Loading - select related() — JOIN-based loading (joinedload) - prefetch related() — separate query loading (selectinload) - Combinable and nestable: select related(\"group\").prefetch related(\"group owner\") Explicit Joins - join() / inner join() , left join() , full join() CRUD - create() , bulk create() - update() , bulk update() , update raw() - get or create() , update or create() - delete() Querying - get() , first() , last() , all() , count() , exists() - only() — select specific columns - select for update() — row-level locking inside an explicit transaction - order by() with E(field, nulls last) / E(field, nulls first) - limit() , offset() , distinct() - aggregate() — Sum , Avg , Count , Min , Max - raw() — execute raw SQL safely - get sql query() — inspect the generated SQL string Session Management - sessionmaker — session created and committed automatically per operation - Direct session — use your own session, c","default_branch":null,"files":null,"tree":[],"storefront":"/r/ViAchKoN","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ViAchKoN/sqlalchemy-query-manager/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}