Show HN: PRQL in PostgreSQL(github.com)

    "A jaw-dropping amount of effort has been spent attempting to bridge the gap between the relational paradigm of SQL and the object-oriented nature of modern programming languages. EdgeDB sidesteps this problem by modeling data in an object-relational way."

  from tracks
  group album_id (
    sort {-milliseconds}
    take 1
  )

    select distinct on (album_id) *
    from tracks
    order by album_id, milliseconds desc;

    select
      album_id 
      ,first_value(id order by milliseconds desc) as longest_track_id
    from tracks
    group by album_id

  int y = x * 2;

  x * 2 assign to new int y;