[feat] sfpegListCmp - Support SAQL queries
Is your feature request related to a problem? Please describe. Provide SAQL support in a similar way to SOQL and SOSL to fetch data.
Describe the solution you'd like Register a SAQL query in the sfpegList configuration record and choose SAQL as query mode.
Describe alternatives you've considered Initially a direct SAQL support within the component was prototyped, but this prevented any deployment on an Org with CRM Analytics not activated. A better option would then be to provide an add-on Apex generic class implementing SAQL queries and relying on the sfpegList configuration record (query template) to know which query to execute.
Additional context Tricky issue is the retrieval of DashboardId and VersionId to be set in the SAQL query, IDs required when executing SAQ queries from Apex.
This is achieveable via a custom Apex implementation with a named credential to call SAQL query endpoints. Example code to be provided soon.