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.

interface Address {  street: string;  city: string;  zip: string;  country: string;} interface User {  name: string;  email: string;  address: Address;    // Nested type}

Multiple Levels

Nested types can contain other nested types.

interface Coordinates {  lat: number;  lng: number;} interface Address {  street: string;  city: string;  location: Coordinates;    // Nested within nested} interface User {  name: string;  address: Address;}

See Also

• Tuples — Lightweight inline structured data
• JSON — Dynamic or semi-structured data
• ClickHouse Nested — ClickHouse official documentation