Property

Basic information

Object type	properties.Property
Since	0.1.0
Dialects	MySQL MariaDB PostgreSQL

JSON format

{
  "obj": "properties.Property",
  "name": "users.name",
  "alias": "name"
}

SQL

users.name AS "name"

JSON Properties

As of version 0.8.0 you can use properties.Property object for PostgreSQL JSON lookups.

JSON

{
  "obj": "properties.Property",
  "name": "users.additional_data -> metadata ->> age",
  "alias": "age"
}

Python

from duckql import  Property

json_property = Property(
    name='users.additional_data -> custom_fields ->> age',
    alias='age'
)

SQL

users.additional_data -> 'metadata' ->> 'age' AS "age"