CRUD:PartiQL Queries
Amazon DynamoDB PartiQL is a SQL compatible query language to select, insert, delete and update data (items) in Amazon DynamoDB.
PartiQL is used by multiple AWS services. DynamoDB supports a subset of PartiQL.
In 2019 Amazon open sourced the PartiQL language. Since then many of the AWS services have now started to support PartiQL. PartiQL queries are data format and data model agnostics - as a result it may be used with a variety of data stores such as relational, nosql databases and even local filesystems and object storage such as amazon s3.
Checkout Partiql.org for more details.
Source: AWS PartiQL announcement blog
Functions
PartiQL supports a subset of SQL functions. Review the functions