litestar-org/advanced-alchemy

View on GitHub

A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy

Stars: 804
Forks: 79
Open beginner issues: 2
Indexed issues: 35
Avg merge: 4d 9h
Merged PRs (30d): 4

Dominant language: Python
License: MIT
Last GitHub push: Sep 7, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

35 open issues indexed

Use distinct Python parameter names for created and updated date-filter dependencies Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

litestar-org/advanced-alchemy#791 · Opened Aug 26, 2026
`service.update()` with many-to-many relationship set in `to_model_on_update` triggers SAWarning "Object of type <X> not in session, add operation along 'Y.z' won't proceed" Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 45/100

litestar-org/advanced-alchemy#790 · Opened Aug 19, 2026
Enhancement: `SQLAlchemyStore` (recommended session store) has no way to purge expired rows Open

documentation enhancement

Difficulty 3/5 1-2 days Newbie friendliness 57/100

litestar-org/advanced-alchemy#787 · Opened Aug 17, 2026
Docs: Usage of nested schema is not explained Open

documentation

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

litestar-org/advanced-alchemy#778 · Opened Jul 27, 2026
Enhancement: allow DateTimeUTC to preserve fractional-second precision Open

Breaking 🔨

Difficulty 4/5 3-5 days Newbie friendliness 48/100

litestar-org/advanced-alchemy#777 · Opened Jul 22, 2026
Bug: get_many_and_count -> do the count on every returning row? Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#762 · Opened Jun 10, 2026
Docs: SSL error on docs.advanced-alchemy.litestar.dev Open

documentation

Difficulty 4/5 3-5 days Newbie friendliness 45/100

litestar-org/advanced-alchemy#734 · Opened May 19, 2026
Bug: create_service_dependencies() filter providers collide when two filtered bundles are merged Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#733 · 1 comment · Opened May 14, 2026
feat: Google ADK integration with first-class artifact storage Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

litestar-org/advanced-alchemy#720 · 1 reaction · Opened Apr 26, 2026
Enhancement: Explore Polymorphism support for services and repositories Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#656 · 2 reactions · Opened Jan 17, 2026
Feature: CompositeService base class for multi-repository orchestration Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

litestar-org/advanced-alchemy#653 · 3 reactions · Opened Dec 29, 2025
Feature: Add `provide_services` context manager for multi-service acquisition outside DI Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

litestar-org/advanced-alchemy#652 · Opened Dec 29, 2025
Docs: add flash message Open

documentation

litestar-org/advanced-alchemy#621 · 1 assignee · Opened Dec 6, 2025
Bug: Unable to pass config to CLI after command Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

litestar-org/advanced-alchemy#604 · 1 comment · Opened Nov 7, 2025
Docs: restructure docs for better readability Open

2.x documentation

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#565 · Opened Oct 10, 2025
🚀 Advanced Alchemy 2.0 -Feedback/Improvments Open

2.x

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#564 · 6 comments · 2 reactions · Opened Oct 9, 2025
Enhancement: add repl/shell command to litestar plugin that automatically imports models etc. Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#559 · Opened Oct 2, 2025
Enhancement: Drop Python 3.9 support Open

2.x enhancement

litestar-org/advanced-alchemy#557 · 1 assignee · Opened Oct 1, 2025
Best Practices when working with Postgres Enum types Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#515 · 2 comments · Opened Aug 19, 2025
MultiFilter with Many-to-Many relationships Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#505 · 1 comment · Opened Aug 4, 2025
Enhancement: Enable direct submodule imports for better IDE support Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#504 · Opened Aug 3, 2025
Enhancement: Built-in PostgreSQL Enum Migration Support using alembic-postgresql-enum Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#492 · Opened Jun 16, 2025
Enhancement: Support for concurrent asynchronous DB queries Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#460 · 10 comments · Opened Apr 25, 2025
Enhancement: Add the possibility to enable index on AuditColumns mixin Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 56/100

litestar-org/advanced-alchemy#382 · 1 comment · Opened Feb 6, 2025
Enhancement: Add environment variable / pyproject.toml section for AA Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#373 · 3 reactions · Opened Jan 28, 2025
Enhancement: Add StatementFilters for relationships & association object patterns Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#364 · Opened Jan 23, 2025
Docs: How to link new object to existing objects? (many-to-many relationship) Open

documentation

Difficulty 3/5 1-2 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#359 · 4 comments · Opened Jan 21, 2025
Enhancement: Support Spanner `INT64` sequence Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 30/100

litestar-org/advanced-alchemy#292 · Opened Nov 15, 2024
Bug: Litestar: "Unexpected default value" exception when using `default=null()` from sqlalchemy Open

wontfix

Difficulty 3/5 1-2 days Newbie friendliness 45/100

litestar-org/advanced-alchemy#238 · 4 comments · Opened Jul 26, 2024
Bug: or Feature? SQLAlchemyDTO ignores include/exclude config when generating field definitions Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#236 · 2 comments · 3 reactions · Opened Jul 23, 2024
Docs: Explain the intended usage of respositories and services Open

documentation

Difficulty 4/5 3-5 days Newbie friendliness 35/100

litestar-org/advanced-alchemy#200 · 3 comments · Opened May 23, 2024
Unintuitive API Open

bug

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#117 · 3 comments · 1 reaction · Opened Dec 27, 2023
Enhancement: Add Big Query support to the repository Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 25/100

litestar-org/advanced-alchemy#54 · 2 comments · Opened Oct 15, 2023
Enhancement: `upsert_many` should use a `merge` or equivalent statement when possible. Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

litestar-org/advanced-alchemy#22 · Opened Sep 17, 2023
Docs: Explain what the Repository Pattern is Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

litestar-org/advanced-alchemy#436 · 6 comments · 3 reactions · Opened Aug 28, 2023

litestar-org/advanced-alchemy

Get new issues in your inbox