Views and SQLObjects

In general, if your database backend supports defining views
you may define them outside of SQLObject and treat them
as a regular table when defining your SQLObject class.

ViewSQLObject

The rest of this document is experimental.

from sqlobject.views import *

ViewSQLObject is an attempt to allow defining
views that allow you to define a SQL query that acts
like a SQLObject class. You define columns based on
other SQLObject classes .q SQLBuilder columns, have columns
that are aggregates of other columns, and join
multiple SQLObject classes into one and add restrictions
using SQLBuilder expressions.

The resulting classes are currently read only, if you find
use for this idea please bring discussion to the mailing list.