Nested Types

Nested types allow embedding complex objects within table rows. Nested types store each field as a separate array column, which can impact query performance for high-throughput paths. Consider Named Tuples for simpler structures stored inline.

Usage

Define a separate model and use it as a field type.

class Address(BaseModel):    street: str    city: str    zip: str    country: str class User(BaseModel):    name: str    email: str    address: Address    # Nested type

Multiple Levels

Nested types can contain other nested types.

class Coordinates(BaseModel):    lat: float    lng: float class Address(BaseModel):    street: str    city: str    location: Coordinates    # Nested within nested class User(BaseModel):    name: str    address: Address

See Also

• Tuples — Lightweight inline structured data
• JSON — Dynamic or semi-structured data