[themerone]

My big wish for SQL is for single row inserts to have a {key: value} syntax.

[zX41ZdbW]

In ClickHouse you can do

    INSERT INTO table FORMAT JSONEachRow {"key": 123}

It works with all other formats as well.

Plus, it is designed in a way so you can make an INSERT query and stream the data, e.g.:

    clickhouse-client --query "INSERT INTO table FORMAT Protobuf" < data.protobuf

    curl 'https://example.com/?query=INSERT...' --data-binary @- < data.bson

[BostonFern]

MySQL has it without the braces.

[nickpeterson]

This would condense lines of code by a lot and prevent a lot of dumb bugs.