SQL is 43 years old – Here’s why we still use it today(blog.sqlizer.io)

    CREATE SCHEMA crm;

    CREATE VIEW public.customers AS
        SELECT c.id, c.contact_name, c.email
        FROM crm.customers AS c;

    CREATE VIEW public.customers AS
        SELECT c.id, c.contact_name, c.email
        FROM crm.customers AS c
        WHERE deleted = false;

  > for some reason the table comes after its fields

  > I write in this style anyway,
  > using a chain of WITH clauses

  > the ORDER BY can't be expressed using field aliases
  > defined at the start of the query

    from e in employee
    join d in department on e.DepartmentID equals d.DepartmentID
    where new string[]{ 'Sales', 'Engineering' }.Contains(d.name)
    orderby e.last
    select e.first, e.last, d.name

    if (player.hasSomeProp) {
      doStuff(player);
    }

    db=# prepare t as select 1 from a;
    ERROR:  relation "a" does not exist at character 28
    STATEMENT:  prepare t as select 1 from a;
    ERROR:  relation "a" does not exist
    LINE 1: prepare t as select 1 from a;
                                       ^
    Time: 0.684 ms

    CREATE TABLE #P (
        name VARCHAR(100),
        count_empty BIT NOT NULL,
        count       INT NULL,
        count_key   AS ISNULL(count,0),
        CHECK ((count_empty = 0 AND count IS NOT NULL) OR (count_empty = 1 AND count IS NULL)),
        PRIMARY KEY (name, count_empty, count_key)
    );