@Andrei_Stefan -- thank you! Yes i considered this. but ultimately, i just ditched the SQL route and have gone with using the java Builders. While not my first choice, I'm finding them quite easy to work with and can perform all of the functions (obviously) that i need to make these queries dynamic.
Thank you for the help!