Add modifier support for ARRAY types and other advanced stuff

[hrach]

I.e. support advanced expression in Postgres like

WHERE "roles"."privileges" ?| array ['*', 'app', 'app.client', 'app.client.entry']

[hrach]

I believe the best way is to support simple list modifier. Something like

query('WHERE [roles.privileges] ?| ARRAY[%modifier]', ['*', 'app', 'app.client', 'app.client.entry']);

The question is how to name the modifier. Currently we use [] suffix to validate array input and we put additional braces around the modifier - %s[] produces ('*', 'app', 'app.client', 'app.client.entry').

Possibilities:

• %s{} other way of representaing a list.
• %s![] wtf char to be different
• %sL[] list array
• ... other options?

cc @JanTvrdik

[hrach]

• %s<>
• %<s>
• %list<s>

[hrach]

%column[] already works the way it does not add (). Also, [] currently means what type is expected, not what the output looks like. So maybe the better way is let [] be and try to add other variation for the expression.

Maybe we could use a spread - something like %...s[]