revamped rowcache. Drop support for anything that requires nested
lookups. Use consolidated IN clauses for tables that have simple
primary keys.