SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness.
Overall
score
85%
Query Building with Select
select() usage
100%
100%
where() filtering
100%
100%
Multiple where() conditions
100%
100%
or_() for categories
100%
100%
order_by() sorting
100%
100%
offset() pagination
100%
100%
limit() pagination
100%
100%
session.exec() execution
100%
100%
Field Configuration and Column Definition
Primary Key Configuration
100%
100%
Unique Constraints
100%
100%
String Length Constraints
100%
100%
Numeric Validation
0%
100%
Decimal Precision
33%
100%
Foreign Key Definition
100%
100%
Cascade Deletion
100%
100%
Default Values
100%
100%
Relationship Configuration
100%
100%
UUID Primary Keys
UUID field type
100%
100%
Primary key configuration
100%
100%
Automatic UUID generation
100%
100%
SQLModel table definition
100%
100%
Session operations
100%
100%
UUID-based retrieval
100%
100%
Custom Relationship Loading Strategies
Model Definition
100%
100%
Relationship Setup
100%
100%
Default Lazy Loading
100%
100%
Joined Loading
100%
100%
Selectin Loading
100%
100%
Polymorphic Inheritance
Base model configuration
0%
0%
Discriminator column definition
33%
33%
Subclass polymorphic identity
0%
0%
Subclass inheritance structure
0%
0%
Polymorphic query usage
33%
0%
Session and CRUD
100%
100%
Database Engine and Table Creation
SQLModel class usage
100%
100%
Field definitions
100%
100%
Engine creation
100%
100%
Table creation
100%
100%
Session initialization
100%
100%
Connection Pooling
Uses create_engine
100%
100%
Production pool_size
100%
100%
Production max_overflow
100%
100%
Production pool_timeout
100%
100%
Production pool_pre_ping
100%
100%
Test StaticPool
100%
100%
Relationship Definition
Relationship() Usage
100%
100%
back_populates Configuration
100%
100%
Foreign Key Definition
100%
100%
Many-to-Many Link Model
100%
100%
Cascade Delete Configuration
100%
100%
SET NULL Behavior
100%
100%
Link Table Structure
100%
100%
FastAPI Integration
SQLModel Database Model
60%
100%
Create Input Model
86%
0%
Public Output Model
0%
0%
Update Input Model
90%
0%
Decimal Field Configuration
50%
100%
FastAPI Endpoint Definition
66%
40%
Session Dependency
0%
0%
ORM to Pydantic Conversion
50%
0%
Inspection and Metadata
Uses inspect()
100%
100%
Accesses column information
100%
100%
Retrieves column types
100%
100%
Identifies primary keys
100%
100%
Accesses table metadata
100%
100%
Install with Tessl CLI
npx tessl i tessl/pypi-sqlmodelTable of Contents