Learn PARTIQL with Real Code Examples

SELECT name, age FROM users
WHERE age > 25;

UPDATE users
SET age = 31
WHERE id = 'user_123';

Querying and modifying data in DynamoDB using PartiQL.

INSERT INTO users VALUE {
    'id': 'user_456',
    'name': 'Charlie',
    'age': 28
};

Inserting a new item into DynamoDB with PartiQL.

DELETE FROM users
WHERE id = 'user_123';

Deleting an item by primary key in DynamoDB.

UPDATE users
SET age = 40
WHERE id = 'user_456' AND age < 35;

Updating an item only if a condition matches.

SELECT name, email
FROM users
WHERE active = true;

Querying only specific attributes from a table.

INSERT INTO users VALUE {
    'id': 'user_789', 'name': 'Dana', 'age': 22
},
{
    'id': 'user_790', 'name': 'Eli', 'age': 35
};

Inserting multiple items into a DynamoDB table.

SELECT * FROM users
WHERE id IN ['user_123', 'user_456', 'user_789'];

Selecting items using the IN clause.

SELECT name, age
FROM users
WHERE age BETWEEN 20 AND 30;

Querying numeric ranges with BETWEEN.

SELECT address.city, address.zip
FROM users
WHERE id = 'user_789';

Accessing nested attributes inside a DynamoDB item.

SELECT name, age
FROM users
ORDER BY age DESC;

Sorting query results using ORDER BY.