AQL ReferenceTypes
Scalar Type
A reference to AQL scalar types like Date, Datetime, Number, Text, and Truefalse, plus types that exist but are not yet operable.
Scalar types are AQL’s generic equivalent of SQL predefined types (types that can be defined as the type of a column). All the currently fully supported scalar types are:
| Type | Description |
|---|---|
| Date | Date value like 2022-01-02 |
| Datetime | Whole datetime value like 2022-01-02 20:10:00 with built-in time zone handling |
| Number | Numeric, Float, Double, and Integer all fall under this category |
| Text | A string of characters. |
| Truefalse | A boolean value, represented as either "true" or "false". |
The following scalar types, while they exist cannot be used in any way, since we don’t support any operations on them:
| Type | Description |
|---|---|
| Time | A point in time, represented as a timestamp or a time string |
| Duration | A length of time, represented as a duration string |
| Composite | A combination of multiple scalar types |
| Binary | A binary data, represented as a sequence of bytes |
| Unknown | A scalar type that cannot be identified or is not yet supported |
Types
A reference to all types in AQL, covering what types are, how they serve as blueprints for objects like models and fields, and the properties each supports.
Text
AQL's text type stores strings of any characters, with operators for equality, pattern matching (like and ilike), list membership, and null checks in filters.