How to use PartiQL with DynamoDB in Node.js

A primer to get you going without needing to bash your head against the AWS documentation.

In this article I’ll take you on a quick tour of PartiQL, showing you how to use PartiQL to query DynamoDB with Node.js. PartiQL is an SQL-compatible query language we can use to interact with our DynamoDB tables. The article aims to be a quick primer to get you going without needing to bang your head against the AWS documentation — which, as you’d expect, is less than amazing. I will assume that you’re at least somewhat familiar with DynamoDB and SQL, and have heard about PartiQL.

The article is broken down into the following sections:

1. Setup
2. Inserts
3. Inserts: Insert Many / Bulk Insert / Batch Insert
4. Selects
5. Selects: Returning only specified attributes
6. Selects: Unmarshalling DynamoDB Records
7. Selects: Using a logical operator (AND, OR, IN, BETWEEN, etc.)
8. Selects: Combining a function and an operator
9. Selects: Parameterized function and logical operator
10. Selects: Selecting from a Local or Global Secondary Index (LSI or GSI)