# SQLAlchemy

## Docs

- [Core SQL API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/core.md): SQLAlchemy Core SQL expression language API
- [Dialects API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/dialects.md): SQLAlchemy database dialects API reference
- [Engine API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/engine.md): SQLAlchemy Engine and Connection API reference
- [Events API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/events.md): SQLAlchemy events system API reference
- [API reference](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/index.md): Complete API reference for SQLAlchemy
- [ORM API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/orm.md): SQLAlchemy ORM API reference
- [Connection Pool API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/pool.md): SQLAlchemy connection pooling API reference
- [Schema API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/schema.md): SQLAlchemy schema definition API reference
- [Types API](https://mintlify.wiki/sqlalchemy/sqlalchemy/api/types.md): SQLAlchemy data types API reference
- [Connection Management](https://mintlify.wiki/sqlalchemy/sqlalchemy/concepts/connections.md): Learn how to manage database connections, execute statements, handle transactions, and configure connection pooling in SQLAlchemy.
- [Engine Architecture](https://mintlify.wiki/sqlalchemy/sqlalchemy/concepts/engine.md): Understand SQLAlchemy's Engine, the core interface for database connectivity, connection pooling, and dialect management.
- [MetaData System](https://mintlify.wiki/sqlalchemy/sqlalchemy/concepts/metadata.md): Learn how to use SQLAlchemy's MetaData to organize database schema definitions, reflect existing schemas, and manage DDL operations.
- [Schema Definition](https://mintlify.wiki/sqlalchemy/sqlalchemy/concepts/schema.md): Learn how to define database schemas in SQLAlchemy using Tables, Columns, Constraints, and other schema constructs.
- [Connections](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/connections.md): Connection objects, statement execution, and result sets
- [Engines](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/engines.md): create_engine(), Engine configuration, and connection URL formats
- [Expression API](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/expression-api.md): Building SQL expressions programmatically with SQLAlchemy Core
- [INSERT, UPDATE, DELETE](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/inserts-updates-deletes.md): Data manipulation with insert(), update(), and delete() statements
- [Core SQL Overview](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/overview.md): Understanding SQLAlchemy Core and when to use it over ORM
- [Connection Pooling](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/pooling.md): Connection pool strategies, QueuePool, NullPool, and pool configuration
- [Constraints](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/schema-constraints.md): Define primary keys, foreign keys, unique constraints, and check constraints
- [DDL Operations](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/schema-ddl.md): DDL generation, CREATE/DROP operations, and schema migrations
- [Tables and Columns](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/schema-table.md): Define database schemas with Table, Column, and MetaData
- [SELECT Statements](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/selects.md): Building queries with select(), join(), subqueries, and CTEs
- [Custom Types](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/types-custom.md): Creating custom types with TypeDecorator and UserDefinedType
- [Type System Overview](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/types-overview.md): Understanding SQLAlchemy type system and type mapping
- [Standard Types](https://mintlify.wiki/sqlalchemy/sqlalchemy/core/types-standard.md): Integer, String, DateTime, Boolean, Numeric, and other built-in types
- [Creating Custom Dialects](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/custom-dialects.md): Build custom SQLAlchemy dialects for proprietary or specialized databases
- [Microsoft SQL Server Dialect](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/mssql.md): SQL Server dialect features, pyodbc driver, and enterprise database capabilities
- [MySQL/MariaDB Dialect](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/mysql.md): MySQL and MariaDB dialect features, drivers, and database-specific types
- [Oracle Dialect](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/oracle.md): Oracle Database dialect features, python-oracledb driver, and enterprise capabilities
- [Dialect System Overview](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/overview.md): Understanding SQLAlchemy's dialect architecture and supported databases
- [PostgreSQL Dialect](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/postgresql.md): PostgreSQL dialect features, drivers, and PostgreSQL-specific types
- [SQLite Dialect](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/sqlite.md): SQLite dialect features, drivers, and embedded database capabilities
- [Type Migration Guidelines](https://mintlify.wiki/sqlalchemy/sqlalchemy/dialects/type-migration.md): Rules and best practices for implementing TypeEngine classes in dialects
- [Installation](https://mintlify.wiki/sqlalchemy/sqlalchemy/installation.md): Install SQLAlchemy with pip, conda, or other package managers
- [Introduction to SQLAlchemy](https://mintlify.wiki/sqlalchemy/sqlalchemy/introduction.md): The Python SQL Toolkit and Object Relational Mapper
- [Declarative Configuration](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/declarative-config.md): DeclarativeBase, declarative_base(), and registry for ORM configuration
- [ORM Event System](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/events.md): Hook into mapper, instance, and session lifecycle events to extend ORM behavior
- [ORM Extensions](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/extensions.md): Extend ORM functionality with hybrid properties, association proxies, and mutation tracking
- [Inheritance Mapping](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/inheritance-mapping.md): Map class hierarchies to database tables with single table, joined table, and concrete table inheritance strategies
- [Loading Techniques](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/loading-techniques.md): Lazy loading, eager loading strategies (joinedload, selectinload), and performance optimization for ORM relationships
- [Mapped Classes](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/mapped-classes.md): Defining ORM mapped classes with Mapped[], mapped_column(), and column properties
- [ORM Overview](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/overview.md): Understanding SQLAlchemy's ORM architecture and when to use ORM vs Core
- [Query Guide](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/query-guide.md): Comprehensive guide to constructing ORM queries using select() statements
- [Queryable Attributes](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/queryable-attributes.md): Working with mapped class attributes for querying, filtering, and comparisons
- [Relationships](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/relationships.md): Defining ORM relationships with relationship(), foreign keys, back_populates, and cascade options
- [Session API Reference](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/session-api.md): Complete reference for Session methods including add(), delete(), query(), execute(), and more
- [Session Basics](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/session-basics.md): Learn about the Session lifecycle, creating sessions, and managing transactions with commit and rollback
- [Session State Management](https://mintlify.wiki/sqlalchemy/sqlalchemy/orm/session-state.md): Understanding object states (transient, pending, persistent, detached), state transitions, and operations like expunge and merge
- [Quickstart](https://mintlify.wiki/sqlalchemy/sqlalchemy/quickstart.md): Start building awesome documentation in minutes
- [ORM Data Manipulation](https://mintlify.wiki/sqlalchemy/sqlalchemy/tutorials/orm-data-manipulation.md): Master inserting, updating, and deleting data with SQLAlchemy ORM
- [ORM Queries](https://mintlify.wiki/sqlalchemy/sqlalchemy/tutorials/orm-queries.md): Master querying with select(), filter(), joins, and advanced patterns
- [Working with Related Objects](https://mintlify.wiki/sqlalchemy/sqlalchemy/tutorials/orm-related-objects.md): Master relationships, lazy/eager loading, and advanced relationship patterns
- [SQLAlchemy Tutorials Overview](https://mintlify.wiki/sqlalchemy/sqlalchemy/tutorials/overview.md): Learn SQLAlchemy from the ground up with comprehensive tutorials covering Core and ORM
- [SQLAlchemy Unified Tutorial](https://mintlify.wiki/sqlalchemy/sqlalchemy/tutorials/unified-tutorial.md): Learn SQLAlchemy Core and ORM fundamentals through an integrated approach