SQL vs NoSQL Comparison

v1.1.1

Compare equivalent SQL, MongoDB, and DynamoDB queries side by side for common operations.

Compares equivalent SQL (PostgreSQL), MongoDB, and DynamoDB query patterns side by side for common operations — select, filter, join, aggregate, insert, update, and delete.

How to use

→Select an operation type from the list to see the three-way SQL/MongoDB/DynamoDB comparison.
→Each column shows the exact query syntax with explanatory comments.
→Use as a reference when migrating between database systems or learning query semantics.

SQL

SELECT *
FROM users
WHERE status = 'active';

MongoDB

db.users.find(
  { status: 'active' }
);

DynamoDB (SDK v3)

const cmd = new ScanCommand({
  TableName: 'users',
  FilterExpression: '#s = :val',
  ExpressionAttributeNames: { '#s': 'status' },
  ExpressionAttributeValues: { ':val': 'active' }
});