Historian Query API

[joepavitt]

With #4911 established, particularly the "Historian" databse, a natural follow-on to this would be a low-code query layer to empower users to gain insights and query their historical data generated on their Broker.

• Simple: SQL query interface to the Historian
• Ambitious: Natural Language Query Layer
  • We want to make this as low-code as possible, as natural language doesn't get much lower-code.
  • We could make this an interface in FlowFuse, but also offer built-in nodes for the Node-RED experience should users want to build their own too.

[joepavitt]

NL Querying Resources:

• https://vercel.com/templates/next.js/natural-language-postgres
• My own work in this space: https://onlinelibrary.wiley.com/doi/full/10.1002/ail2.21