Amazon QLDB PartiQL reference

Amazon QLDB supports a subset of the PartiQL query language. The following sections describe the QLDB implementation of PartiQL.

Note

QLDB does not support all PartiQL operations.

This reference provides basic syntax and usage examples of PartiQL statements that you manually run on the QLDB console or the QLDB shell. For code examples that show how to programmatically run similar statements using the QLDB driver, see the tutorials in Getting started with the driver.

Topics

• What is PartiQL?
• PartiQL in Amazon QLDB
• Data types
• QLDB documents
• Querying Ion with PartiQL
• PartiQL statements
• PartiQL functions
• PartiQL operators
• Reserved words
• Amazon Ion data format reference

What is PartiQL?

PartiQL provides SQL-compatible query access across multiple data stores containing structured data, semistructured data, and nested data. It is widely used within Amazon and is now available as part of many AWS services, including QLDB.

For the PartiQL specification and a tutorial on the core query language, see the PartiQL documentation.

PartiQL extends SQL-92 to support documents in the Amazon Ion data format. For information about Amazon Ion, see the Amazon Ion data format reference.

PartiQL in Amazon QLDB

To run PartiQL queries in QLDB, you can do one of the following:

• Use the Query editor on the AWS Management Console for QLDB.

• Use the command line QLDB shell.

• Run them programmatically using a provided QLDB driver.

For information about using these methods to access QLDB, see Accessing Amazon QLDB.