remove sql temp table and simplify interface
add tests to verify auto registration of queue partitions