To use lists of int/str in where clauses we are currently using utility methods which transform ['string1', 'string2'] -> "'string1' , 'string2'" and [1, 2] -> '1, 2' so they can be used in a queries where clause WHERE cid in ({cid_list}).
These utility methods should be bundled in this package to have an optimal, unified way to transform the lists.
Since SQL Where statements have a maximal character limit, a check for that could also be included here.
To use lists of int/str in where clauses we are currently using utility methods which transform
['string1', 'string2'] -> "'string1' , 'string2'"and[1, 2] -> '1, 2'so they can be used in a queries where clauseWHERE cid in ({cid_list}).These utility methods should be bundled in this package to have an optimal, unified way to transform the lists.
Since SQL Where statements have a maximal character limit, a check for that could also be included here.