top | item 47123126

(no title)

jeltz | 6 days ago

Matching SQL in features is very hard, especially if you also want to make it more sane and more powerful at the same time while also wanting to be able the generate valid SQL from your syntax. So I am not surprised that it stalled out.

discuss

order

Taikonerd|6 days ago

Sure, but they never intended to support everything you can do in SQL. For example, they say on the Roadmap page that they're only going to support SELECTs -- there won't be a PRQL way to do an INSERT, UPDATE, etc.

jeltz|6 days ago

I was only thinking about SELECT queries when I wrote ny comment because those are the hard things to implement.

andrew_lettuce|6 days ago

When it comes to SQL it's the select that's by far the majority of the work though, the hard work with mutating operations is on the database implementation, not really the syntax or query plan