The web modules come with an Object Relational Mapper, web.database.object. This allows developers to manipulate the underlying SQL database with no knowledge of SQL whatsover. This approach also allows non-SQL databases to be used as a data store.
As a developer all you have to do is define the appropriate database tables.