GENERAL * port Oracle backend to UFFI. TESTS TO ADD * CACHE-TABLE-QUERIES * :VOID-VALUE COMMONSQL SPEC * Missing: UPDATE-OBJECT-JOINS * Incompatible >> The functional sql interface SELECT o keyword arg :refresh should function as advertised o should return (values result-list field-names) o should coerce values returned as strings to appropriate lisp type QUERY o should coerce values returned as strings to appropriate lisp type for SQLite backend >> The object-oriented sql interface DEF-VIEW-CLASS o get :target-slot working o implement :retrieval :immediate DO-QUERY,MAP-QUERY,LOOP o should work with object queries as well as functional ones >> Symbolic SQL syntax o Complete sql expressions (see operations.lisp) substr some order-by times nvl null distinct except intersect between userenv o variables (e.g., table identifiers) should be instantiated at runtime NOTES ABOUT THE BACKENDS MYSQL drop-index: requires a table to be specified with the :from keyword parameter views: mysql does not support views queries: nested subqueries are not supported SQLITE create-view: column-list parameter not supported