Bear in mind views will have to be changed each month when a new table is created, and will become big and slow.
Brain dump follows as I don’t work with firebase
I assume firebase will allow you to get a list of tables and filter those down to those you need. It may be possible to use that filtered list to create a Yii controller and model that accepts any table name from a select list or uri.
ActiveModel is not the only fruit. In Yii you can create sql statements on the fly to concatenate a table name into the query. The API Database Access objects may provide ideas, though may not support firebase directly.