Sam’s SQL notes

Author

Samuel Colin

Published

January 6, 2026

Welcome!

Welcome to Sam’s notes on SQL.

Create a connection:

con <- DBI::dbConnect(duckdb::duckdb(), dbdir = ":memory:")
SELECT 'hello';
1 records
‘hello’
hello