A Short Story About SQL’s Biggest Rival

Re:A Short Story About SQL’s Biggest Rival by sergeykish on Saturday October 10, 2020 @06:26AM (#24737942)

Unbiased samples should match typography

QUEL:

    range of e is employee
    retrieve into w (comp = e.salary / (e.age - 18))
    where e.name = "Jones"

SQL:

    select
    (E.Salary / (E.Age - 18)) as COMP
    from EMPLOYEE as E
    where E.Name = "Jones"

Now QUEL looks like modern language while SQL is jarred mess.

[ Parent | on HN ]

Re:A Short Story About SQL’s Biggest Rival by sergeykish on Saturday October 10, 2020 @08:40AM (#24738552)

Also `into w` is

> To store the results of the retrieve in a new table, specify `into tablename` [1].

matching SQL:

    create table w as
    select (e.salary / (e.age - 18)) as comp
    from employee as e
    where e.name = "jones"

[ Parent | on HN ]