Spring Support SQUARE brackets [] around NAMED parameter

At the moment, if sql statement has a variable in square brackets, then the name of the variable will be incorrect. For example: SELECT ARRAY[:ext]; We'll get "ext]" instead of "ext".

But: SELECT ARRAY[:ext ]; --with white space We'll get "ext".

Comment From: schauder

I agree with the OP. This makes sense for the array syntax at least of Postgres and DB2. It might even be the standard, but I don't know.

We should probably also make sure that expansion of collections into a comma separated list happens, so that this works when ext isn't just a singular argument but a collection of things, which would make sense for arrays.

An alternative workaround is to pass in a java.sql.Array directly.