PQL Reference

Statements

• SELECT
• INSERT
• MERGE
• UPDATE
• DELETE

Expressions

• Paths
• Data types
• Functions

Paths

• Full- and qualified-path searches
• Path-scoped predicate
• Path-scoped projection

Data types

• Integers
• Floats
• Regular expressions
• Strings
• Timestamps

Functions

• String functions
• abbreviate()
• downcase()
• format()
• lower()
• regex()
• substring()
• upcase()
• upper()
• General functions
• coalesce()
• nvl()
• Tree functions
• child()
• first()
• id()
• join()
• num_children()
• parent()
• path()
• zip()
• History functions
• available_history()
• created_at()
• has_history()
• history()
• observed_at()
• raw_history()
• Aggregate functions
• count()
• max()
• min()
• sum()

Functions (cont.)

• Type-cast functions
• date()
• float()
• int()
• integer()
• string()
• time()
• timestamp()

Operators

• @
• -
• +
• ~
• **
• ||
• *
• /
• +
• -
• ^
• &
• |
• <<
• >>
• >
• <
• >=
• <=
• !=
• =
• IS
• LIKE
• BETWEEN
• ISNULL
• NOTNULL
• NOT
• AND
• OR

Miscellaneous

• Boolean expressions
• Floating points
• Identifiers
• Regular expressions
• Reserved words
• Subqueries