B4J Question SQL development friendly enviroment... (need advice)

Hi guys,

Following up on my quest to get started with RDC, I came to the following conclusion(s):

1. I will always need a midleware of some kind, being it B4J (JRDC) or PHP based.
2. Theses midleware use "static" calls to the data base (I cannot change the query itself, only the passed parameters), so for any number of unique queries I will need the same number of PHP scripts or define the query in a config file

These are not very developement friendly solutions... It seems to me that a try/fail approach is not easy to implement, as it will not sufice to change the "client side" code, but also the "server side" calls.

So I ask you, how do you cope with it?

I am considering creating a "temporary" SQLite local DB for development and defining my needed calls, and then find a way of converting that DB into MySQL and "export" my queries for easy handling and adding to the server.

What do you guys think?