We have a bug tracking system that uses an Oracle database as the backend server. The DB admin has exported two views of the data. There are read-only, so we can do SQL queries. To modify the database we have to go through GUI or command line tools so that no one disturbs the database.
I'm working on a Catalyst app where I would like to suck the field definitions out of this view, just as if it were a table. Just one big flat definition. I have my own database where I'll store relationships to these items by their primary key which is an integer.
Is there a way to get DBIX::Class::Loader / make_schema_at to generate the definition of this? I would be using it as a Catalyst Result class.