How about trailing commas in SQL?

1. prql

   1 127 10,208 9.7 Rust

   PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

   

   I feel the same way about SQL too, it's set and difficult to shift. But I also look at PRQL longingly - https://prql-lang.org/

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. duckdb-wasm

   2 19 1,525 9.2 TypeScript

   WebAssembly version of DuckDB

   

   DuckDB has this feature:

   duckdb> select 1,2,;

   returns 1 and 2

   https://shell.duckdb.org

4. jsonlines

   3 13 145 4.8 CSS

   Documentation for the JSON Lines text file format

   

   You probably want jsonlines. Being able to open a file in append mode without needing to parse the whole thing is great.

   https://jsonlines.org/

5. ClickHouse

   4 240 40,175 10.0 C++

   ClickHouse® is a real-time analytics database management system

   

   ClickHouse has support for trailing commas for several years.

   I recommend looking at ClickHouse (https://github.com/ClickHouse/ClickHouse/) as an example of a modern SQL database that emphasizes developer experience, performance, and quality-of-life improvements.

   I'm the author of ClickHouse, and I'm happy to see that its innovation has been inspired and adopted in other database management systems.

6. xtdb

   5 19 2,642 9.9 Clojure

   An immutable SQL database for application development, time-travel reporting and data compliance. Developed by @juxt

   

   In XTDB you can now use (trailing) commas instead of AND: https://github.com/xtdb/xtdb/pull/3985

7. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

Suggest a related project