Georg Traar

Also [TypeORM](https://typeorm.io/#/) uses named primary key constraints.

The code in this repository is available under Apache License 2.0 (also see https://github.com/crate/crate/blob/master/LICENSE ) Feel free to modify and use the postgres wire protocol implementation within the scope of...

@dssysolyatin I don't think there is a concrete plan to change anything like this right now, as our main focus for CrateDB is the wire protocol interface. If you think...

> If I understand this correctly it sounds a bit like a use-case for jsonpath support: https://www.postgresql.org/docs/12/functions-json.html#FUNCTIONS-SQLJSON-PATH I think it is/could be more than "just" an operator, but rather also...

so would a `url_parse()` function, that parses url string to an object like ```sql OBJECT(STRICT) AS ( scheme TEXT, hostname TEXT, domain TEXT, port INTEGER, path ARRAY(TEXT), parameters OBJECT(DYNAMIC) AS...

> The main thing is I'd like to be able to do GROUP BY on parts of a URL. Can crate efficiently do GROUP BY on object subscripts? Absolutely, Object...

> querystring parameters (take ?this=that&color=blue&validate should turn into key value pairs that can be searched with a WHERE clause easily or used in a GROUP BY) How to handle duplicates...

Not quite sure how this would fit with SQL 🤷 how about using array splitting instead? ```sql CREATE TABLE IF NOT EXISTS path_table ( "site" STRING, "path" STRING, "path_array" GENERATED...

Seems like ES since v7.0 sets max to 1024 by default. `X` probably should be a multiple of 2 https://www.elastic.co/guide/en/elasticsearch/reference/7.x/index-modules.html https://www.elastic.co/guide/en/elasticsearch/reference/7.0/breaking-changes-7.0.html#_document_distribution_changes

If it isn't too many rows an UDF might be a (temporary) solution: ```sql cr> CREATE TABLE arr_sum (arr ARRAY(INTEGER)); cr> INSERT INTO arr_sum VALUES ([1,2,3]),([0,1,2]); ``` ```sql CREATE OR...