You should take a look at KiokuDB. It is probably what you want, and although it is rather new, it is in production in some pretty important apps.
It is an object database rather than an ORM, which means that you can't edit the database from outside of the Perl world. If you just want to query the objects with SQL, though, you can use GIN to index the necessary attributes in your app. (The docs describe this in detail, it is a common thing to do.)
This probably sounds "different" than what you are used to, but KiokuDB has made our apps a lot cleaner than a relational database + DBIC, and in many cases, more efficient. You will also have a variety of choices for backends; you can use Oracle if you want, but you can also use Berkeley DB, CouchDB, Amazon SimpleDB, and so on... without changing your app's code.