Hi, I'm looking to develop my first web API in Powerbuilder 2019R2 to replace some aging PHP applications. Our PHP applications create a lot of dynamic sql (generally the from and where clauses) based on the arguments passed from the client. I'm looking to replicate this dynamic creation of SQL with SqlQueryBuilder. Is that the preferred way to go? Or is it possible to create dynamic SQL with the new .Net DataStore?
My other question regarding the SqlQueryBuilder is whether it can load an existing SQL statement that I can then modify, or whether I need to create it from scratch by specifying everything?