Clarinet is a web server that securely caches your database in memory for very fast retrival over the web.
It supports all databases that have a well made ODBC driver.
It provides its own query language based on XPATH, allowing you to do joins between tables for you to get exactly what you want.
It can designed to run stand alone or alongside an existing web site on platforms such as LAMP or ASP.net.
It can scale in a cluster, but it is very fast so you may not need to.
A good developer can do all these things, however switching between one technology and the next, is difficult to do and slows you down, you become a jack of all trades and a master of none.
Clarinet provides a way of accessing and controlling data from the database without writing any server side code. It allows you to concentrate the business logic in one place: the web browser. This gives the client a more responsive experience while simplifying the development and reducing your hardware and bandwidth costs.
As the internet is not a benign environment, good security is vital. Clarinet has a unique and very powerful security layer, giving you full row level security by means of an XPATH filter, per action, table and user combination.