If you’re a developer, and haven’t checked out BerlinDB – you should definitely give it a gander. It’s a database engine that provides WP_Query-like syntax to custom database tables. We use it on several projects at @sandhillsdev

github.com/berlindb/core