TESTS TO ADD

* CACHE-TABLE-QUERIES
* Test that ":db-kind :key" adds an index for that key. This is complicated by different
  backends showing autogenerated primary key in different ways.
* Large object testing
* Test bigint type
* :db-constraint tests
* test *db-auto-sync* 
* test :retrieval :deferred joins

COMMONSQL SPEC

* Missing: 

  UPDATE-OBJECT-JOINS 

* Incompatible 

 >> The functional sql interface 
  
    SELECT 
      o keyword arg :refresh should function as advertised 

 >> 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 

OPTIMIZATIONS

* Revisit result-type list creation,perhaps caching

POSSIBLE EXTENSIONS

* port Oracle backend to UFFI
* large object support 
* add support for prepared statements


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