Operation 	Snippet
Pretty-printing floats 	SELECT (10 / 9)::DECIMAL(15, 3);
Copying the schema 	CREATE TABLE tbl AS FROM example LIMIT 0;
Shuffling data 	FROM example ORDER BY hash(rowid + 42);
Specifying types when reading CSVs 	FROM read_csv('example.csv', types = {'x': 'DECIMAL(15, 3)'});
Updating CSV files in-place 	COPY (SELECT s FROM 'example.csv') TO 'example.csv';

https://duckdb.org/2024/08/19/duckdb-tricks-part-1.html