News for hackers. Stuff that matters.

A comment on PRQL – A proposal for a better SQL. Parent comment

Re:PRQL – A proposal for a better SQL by BeefWellington on Tuesday January 25, 2022 @02:15AM (#30069083)
You've never authored a SQL query that does things like check special functions that don't exist in a table?

For example:

    select @@version
[ Parent | on HN ]
Re:PRQL – A proposal for a better SQL by fragmede on Tuesday January 25, 2022 @02:30AM (#30069174)
Seems easy enough to work around with a magic table name in this hypothetical future reworked dialect of SQL?

    from @@special
    select version
[ Parent | on HN ]
Re:PRQL – A proposal for a better SQL by tapas73 on Wednesday January 26, 2022 @01:23AM (#30082425)
or

    from dual
    select @@version
[ Parent | on HN ]