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.