If it doesn't exist already, could we please have a node that can convert collection cells to java.sql.Array implementing objects?
I ask because I'm trying to push collections into a PostgreSQL database using the database writer node, but it's complaining that they're varchars. I therefore need to convert them to java.sql.Array implementing objects first, then submit them.
It would also be useful to convert the other way too, so that KNIME can understand read array data.
Converting java.sql.Array to collections and vise versa in the database writer and reader nodes might be a better solution, since you'll already know what type of database you're working with.