The UltraESB v1.3.0 introduces JSON Data Services which does exactly this! Create data services by specifying a SQL file and a URI pattern. The URI patterns allows you to specify variables, that correspond to the SQL statement as shown in the following example.

URI Pattern ->  /byDeptAndDivision/{department:INTEGER}/{division:INTEGER}?{age:INTEGER},{sex:VARCHAR}

SQL --> select * from employee where division = :division and department = :department and sex = :sex and age > :age

The results of the SQL are converted into a JSON response and returned. Read the full article that shows many examples with a hypothetical employee database. The UltraESB supports the creation of REST services that updates the database as well using the HTTP PUT, POST and DELETE methods.

JSON Data Services