We run a multi-client ERP system (PostgreSQL backend) with 280+ SQL-based reports. Users select reports via Java UI, but we face challenges: high maintenance, limited flexibility, performance bottlenecks, and lack of deeper insights.
Context:
10+ years of growing store data (daily additions)
Multi-client setup → strict data privacy/security required