I am used to an Oracle world where there was an ability to build Oracle Views - i.e virtual tables using inner or outer joins on ANY datafield(s) (not just primary) …..To try and emulate this in Baserow means I have to write automation/javascript whatever to batch or dynamically maintain a new table which combines the 1,2 or 3 linked tables I need to give me the data I want.
There is no really simple “report writer” in Baserow as far as I can see (Domo, Power BI, SSRS etc etc are too complex and come at cost).
I have tried using ODBC on my self-hosted instance so that I could provide this capability with MS Access but the internal data structures in how Baserow provides what I see in the UI is defeating me trying to do that.
What we need is - without any new table at all - is the ability to define multi-tables with inner or outer joins on multiple datafields (max 3?) on multiple tables (max3?) and presented on demand as a complete virtual table with the ability to store filters, groups and sorts on the whole output as usual.
Best I can think of at the moment is downloading each table as CSV - pickup in MS Access and do my xref/listing of data side by side from multiple tables there - cumbersome for me as a one off but certainly not a sustainable solution for me and certainly not for my end users.
A feature like this elevates Baserow into another league away from the focus of one-table-at-a-time noloco tools.
