3 ms·
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]: http
by dleeftink 1y ago
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 https://duckdb.org/community_extensions/extensions/psql.html
[1]: https://duckdb.org/community_extensions/extensions/prql.html https://duckdb.org/community_extensions/extensions/prql.html
- geysersam 1y agoIn 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
- howardbannister 1y agoThe duckdb local ui does that I believe: duckdb -ui More here: https://duckdb.org/2025/03/12/duckdb-ui.html https://duckdb.org/2025/03/12/duckdb-ui.html
- paradox460 1y agoAnd in elixir land we've had similar pipes and composition through ecto, for the major rdbms
- account42 1y agoAn unfortunate name when PSQL is already a commonly used shorthand (including the official client command name) for a competing SQL-based database engine.
- mikeen 1y agoGoogle actually started pipe syntax, https://news.ycombinator.com/item?id=41338877 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).