Friendly SQL with DuckDB

friendly-duckdb-01.sql

/*
    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
*/


select version();


create or replace table ducks(
    duck_name varchar,
    duck_type varchar
);
insert into ducks
values
    ('Rubber Ducky', 'household'),
    ('Donald Duck',  'cartoon  '),
    ('Daffy Duck',   'cartoon  ')
;


from ducks
select * replace(
    duck_name.lower().trim() as duck_name
)
order by all
;

This is part of the following LinkedIn post:

https://www.linkedin.com/posts/bill-wallis_sql-analyticsengineering-activity-7222344408795389955-jtwV