← Back to context Comment by themerone 1 year ago My big wish for SQL is for single row inserts to have a {key: value} syntax. 3 comments themerone Reply zX41ZdbW 1 year ago 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 1 year ago MySQL has it without the braces. nickpeterson 1 year ago This would condense lines of code by a lot and prevent a lot of dumb bugs.
zX41ZdbW 1 year ago 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
In ClickHouse you can do
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.:
MySQL has it without the braces.
This would condense lines of code by a lot and prevent a lot of dumb bugs.