Can my DB?

Apply a WHERE condition directly inside an aggregate function call to selectively include rows in the aggregate.

Define named temporary result sets using WITH clauses, including support for recursive queries.

Return one row per distinct combination of the listed columns, with ORDER BY picking which row to keep. PostgreSQL-only.

Extensions to GROUP BY that compute aggregates across multiple grouping combinations in a single query.

A join where the right-hand side can reference columns from the left-hand side, enabling per-row subqueries and table function calls.

Clauses that cap the number of rows returned and skip past an offset — LIMIT / OFFSET, FETCH FIRST, TOP.

Rotate rows into columns (PIVOT) or columns into rows (UNPIVOT) for cross-tabulation and data reshaping.

Common Table Expressions that reference themselves to traverse hierarchical or graph-structured data.

Efficiently sample a random subset of rows from a table without scanning or sorting all rows.

Use a VALUES clause as a derived table in FROM, providing inline rows without creating a physical table.

Compute values over a set of rows defined relative to each row, without collapsing those rows the way GROUP BY does.