[CAMEL-9711] camel-sql - Allow to use IN queries where the parameter is expanded

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.17.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Claus Ibsen
• Reporter: Claus Ibsen
• Created: 15/Mar/16 15:59
• Updated: 18/Mar/16 10:08
• Resolved: 18/Mar/16 10:08

Description

So you can do a

select * from foo where bar IN :#myValues

And then have myValues being expanded into a list of values separated by comma. The trick is to know if the values should be quoted or not, eg

IN (1, 2, 3)

or

IN ('1', '2', '3')

So we may need a way to specify that. Or defer if its numbering then its not quoted, and non numeric is quoted. But then you may want numeric quoted still.