News for hackers. Stuff that matters.

A comment on Left to Right Programming. Parent comment

Re:Left to Right Programming by dleeftink on Monday August 18, 2025 @02:33PM (#44943809)
PSQL (and PRQL) use this ordering, and a similar pipe/arrow notation has recently been added to BigQuery.

Check out the DuckDB community extensions:

[0]: https://duckdb.org/community_extensions/extensions/psql.html

[1]: https://duckdb.org/community_extensions/extensions/prql.html

[ Parent | on HN ]
Re:Left to Right Programming by geysersam on Monday August 18, 2025 @04:14PM (#44944794)
In duckdb you can also start with `FROM .. SELECT ..` without using the PSQL extension.

But I haven't found a good editor plugin that is actually able to use that information to do completions :/ If anyone knows I'd be happy to hear it

[ Parent | on HN ]
Re:Left to Right Programming by howardbannister on Tuesday August 19, 2025 @08:33AM (#44950832)
The duckdb local ui does that I believe:

duckdb -ui

More here: https://duckdb.org/2025/03/12/duckdb-ui.html

[ Parent | on HN ]
Re:Left to Right Programming by paradox460 on Monday August 18, 2025 @08:39PM (#44947023)
And in elixir land we've had similar pipes and composition through ecto, for the major rdbms
[ Parent | on HN ]
Re:Left to Right Programming by account42 on Wednesday August 20, 2025 @05:23AM (#44960201)
An unfortunate name when PSQL is already a commonly used shorthand (including the official client command name) for a competing SQL-based database engine.
[ Parent | on HN ]
Re:Left to Right Programming by mikeen on Saturday August 23, 2025 @05:21PM (#44999242)
Google actually started pipe syntax, https://news.ycombinator.com/item?id=41338877

Now it is supported by DuckDB, BigQuery, Spark SQL, Firebolt, and probably others. I use it more and more (with BigQuery).

[ Parent | on HN ]