The OODML is designed to be powerful and expressive, while remaining familiar to users of the FDML. To achieve this aim, some of the functions and macros in the SQL interface have been
overloaded
-- particularly the
select
function and the iteration constructs.
list-classes &key
database
The
list-classes
function returns a list of the class objects of the CLOS classes which have been defined by
def-view-class
for
database
.
select selections &rest args &key all set-operation distinct from where
group-by having order-by database
The
select
function is common across the both the functional and object-oriented SQL interfaces. If
selections
refers to a view class by supplying its symbolic name then the select operation becomes object-oriented -- returning a list of instances instead of a list of attributes. The symbol
slot-value
is a valid SQL operator for use within the
where
clause.