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.
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}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;}Use nested types when the structure is known and fixed. Use JSON for dynamic or variable structures.