Bilbottom

Bilbottom

/*
    Mermaid + DuckDB for generating customer hierarchy diagrams

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-09
*/


select version();

Bilbottom

/*
    DuckDB for dynamically parsing JSON data from a URL

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-09
*/


select version();

Bilbottom

/*
    DuckDB's `FROM` statement accepts glob patterns

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-10
*/


select version();

Bilbottom

/*
    The SQL `VALUES` statement (in DuckDB)

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-21
*/


select version();

Bilbottom

/*
    Datelist integers for true/false attribute history

    DuckDB version: 0.10.2

    Bill Wallis, 2024-06-19
*/


select version();

Bilbottom

select version();  -- DuckDB v1.0.0


/* https://www.linkedin.com/posts/constantin-lungu-668b8756_sql-bigquery-dataengineering-activity-7212478238265139201-dS4y */

create or replace table weather_alerts (
    city_id    int,
    alert_name varchar,
    valid_from date,
    valid_to   date,

Bilbottom

/*
    Friendly SQL with DuckDB

    DuckDB version: 1.0.0

    Bill Wallis, 2024-07-25

    Demonstrating some DuckDB features described by Alex Monahan at:

        https://duckdb.org/docs/sql/dialect/friendly_sql

Bilbottom

/*
    Friendly SQL with DuckDB (part 2)

    DuckDB version: 1.0.0

    Bill Wallis, 2024-07-27

    Demonstrating some DuckDB features described by Alex Monahan at:

        https://duckdb.org/docs/sql/dialect/friendly_sql

Bilbottom

/*
    Three-valued logic

    DuckDB version: 1.0.0

    Bill Wallis, 2024-07-27

    https://modern-sql.com/concept/three-valued-logic
*/