https://modern-sql.com/use-case/select-without-from
SQL SELECT without FROM should read VALUES without INSERT
Every SELECT needs a FROM clause according to the SQL standard. VALUES is like SELECT without FROM.
sql selectwithoutreadvalues
https://modern-sql.com/feature/listagg
SQL LISTAGG concatenates values of multiple rows into an delimited string such as CSV.
LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior...
multiple rowssqlvalues
https://modern-sql.com/feature/is-distinct-from
Modern SQL: IS DISTINCT FROM — A comparison operator that treats two NULL values as the same
In SQL NULL = NULL isn’t true. Use IS NOT DISTINCT FROM instead of equals (=) for null-aware comparisons.
modern sqldistinctcomparison
https://modern-sql.com/use-case/query-drafting-without-table
SQL VALUES: developing queries without creating required tables
Need to draft a query without creating tables and test data first? That's actually possible using the VALUES clause.
sql valueswithout creating
https://modern-sql.com/feature/values
SQL VALUES: Creates rows from the provided column expressions
The SQL VALUES clause can do more than you think: it can produce multiple rows and even be used instead of SELECT.
sql valuescreatesrowsprovided
https://modern-sql.com/use-case/reduce-network-latency-for-insert
Loading SQL databases faster with INSERT VALUES
Add multiple rows with a single INSERT statement to reduce latencies. Alternativley: use a batch API.
sql databasesloadingfaster