Function SQL-EXPRESSION — Constructs an SQL expression from supplied keyword arguments.
Function
sql-expression &key string table alias attribute type => result
A string.
A symbol representing a database table identifier.
A table alias.
A symbol representing an attribute identifier.
A type specifier.
A object of type sql-expression.
Returns an SQL expression constructed from the supplied arguments which may be combined as follows:
attribute and type;
attribute;
alias or table and attribute and type;
alias or table and attribute;
table, attribute and type;
table and attribute;
table and alias;
table;
string.
(sql-expression :table 'foo :attribute 'bar) => #<CLSQL-SYS:SQL-IDENT-ATTRIBUTE FOO.BAR> (sql-expression :attribute 'baz) => #<CLSQL-SYS:SQL-IDENT-ATTRIBUTE BAZ>
None.
None.
An error of type sql-user-error is signalled if an unsupported combination of keyword arguments is specified.
sql |
sql-operation |
sql-operator |
None.