Waiting for SQL:202y: Group by All

14 comments

• elygre 4 hours ago ago

  Let me reference fields as I create them:

    select xxxxx as a
         , a * 2 as b

  [-]
  • cyberax 10 minutes ago ago

    SQL needs to have `select` as the _last_ part, not the first. LINQ has had this for 2 decades by now: "from table_a as a, table_b as b where ... select a.blah, b.duh".

  • zX41ZdbW 2 hours ago ago

    This will be great! One of the things ClickHouse has had since 2016.

• chewxy 43 minutes ago ago

  BigQuery has that and I've been loving using it since they introduced it

• elchief an hour ago ago

  duckdb has it

  https://duckdb.org/docs/stable/sql/query_syntax/groupby

• cm2187 2 hours ago ago

  Snowflake has that, once you start using it, it's painful to go back.

• SigmundA 6 minutes ago ago

  SELECT * EXCEPT(col_name) next please.

• Exuma 4 hours ago ago

  Also just let me reference the damn alias in a group by, FUCK

  [-]
  • sbuttgereit 4 hours ago ago

    At least in PostgreSQL, both by alias and ordinal are possible:

      localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:15 PST 2025]
      > create table test (a_key integer primary key, a_group integer, a_val numeric);
      CREATE TABLE
      Time: 3.102 ms
    
      localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:25 PST 2025]
      > insert into test (a_key, a_group, a_val) values (1, 1, 5.5), (2, 1, 2.6), (3, 2, 1.1), (4, 2, 6.5);
      INSERT 0 4
      Time: 2.302 ms
    
      localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:58 PST 2025]
      > select a_group AS my_group, sum(a_val) from test group by my_group;
       my_group | sum
      ----------+-----
              2 | 7.6
              1 | 8.1
      (2 rows)
      
      Time: 4.124 ms
      localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:03:15 PST 2025]
      > select a_group AS my_group, sum(a_val) from test group by 1;
       my_group | sum
      ----------+-----
              2 | 7.6
              1 | 8.1
      (2 rows)
      
      Time: 0.360 ms

  • zX41ZdbW 2 hours ago ago

    I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.

  • kermatt 2 hours ago ago

    PostgreSQL and DuckDB support this, which makes MSSQL feel like a dinosaur in context.

  • mberning 4 hours ago ago

    Some do. It would also be nice to reference by ordinal number similar to order by. Very handy for quick and dirty queries. I can see the issue though that people start to lean on it too much.

• oulipo2 an hour ago ago

  Not directly related, but I saw this project recently of a data language by google which is quite cool https://www.malloydata.dev/

• dorianmariecom 3 hours ago ago

  would be nice