In the codebase i work on professionally we use zend_db for a similar approach, except we use named parameters (on oracle). It works well until you have to cons

In the codebase i work on professionally we use zend_db for a similar approach, except we use named parameters (on oracle). It works well until you have to construct complex queries, and then the temptation to start concatenating quoted values into the query is overpowering. I will stew a bit more on what approach (if any) is best for queries.