Best way to export data do SQL database

Elastic Stack Elasticsearch
1

Hi,
could you help me advice
What tools/techniques do you recommend to export data to SQL Database.
(PostgreSQL/Oracle or any other)
I need aggregations results export to SQL database (continuous query).

I supposed to use Transform API and later export them using some tool.
Scroll API and some transformation.

2

Don't believe there is an out of the box solution.

I would pick a programming language that has an Elastic Client and read from the index you create using the Transform API and then use JDBC to write the results to the DB of your choice.