I've built pre-parsing layers for queries that can explode out params properly for IN() handling - though depending on your SQL variant you can also get away wi

I've built pre-parsing layers for queries that can explode out params properly for IN() handling - though depending on your SQL variant you can also get away with string passing an array to get around that. Conditional WHERE seems unapproachable with this tool - which is one of my doubts about the need of a tool like this. If you instead approach your SQL by having each query wrapped in a function in an isolated part of your code base you, as a company/team/whatever, can choose how much logic to let reside inside of those functions - building up conditional WHERE clauses is a very common thing to need to do.