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