Remove table engine juggling.

It goes against being explict and getting what you typed into the
framework. If people want to use memory tables they can request that in
their fixtures.
Use managed connections instead of creating new ones.

This fixes missing tables in Sqlite with memory databases, and solves
issues where default installs of postgres complain about maximum
connections.