Consider exposing a JSON API and developing the UI as a client-side app

[jonasfj]

Escaping strings correctly and tweaking templates can be error-prone and slow...

It's often easier to simply expose the data through REST APIs that return plain JSON. Then write a client-side only application that uses the REST API to visualize and filter the data..

This also makes it feasible to build custom dashboards, and allows other services to call in an extract data.

One of the key benefits is that simplifies the security model. Your interactive APIs don't have to worry about XSS. And you can iterate much faster on the client side using production data if your CORS headers permits access.