Dear all,
Wouldn’t it be great to have a plugin covering SQL/database queries into the spreadsheet editor for MSSQL, MariaDB, PostgreSQL, … ?
I think on sth like Powerqueries in Excel but perhaps build on R and python and predefined opensource technology to add statements and load data in a cell.
Is there any ongoing project to cover such functionality?
Kr
–P.
Hey @promexio, 
Great idea!
As far as I know, we already have an open feature request for adding external data connections (MSSQL, PostgreSQL, etc.) to ONLYOFFICE Desktop — basically the ability to connect to a database, run queries, and pull the results into cells (very similar to Power Query in Excel).
Is that exactly what you’re suggesting, or are you thinking of something different?
Let me know and I’ll link your request to the existing one so it gets more votes! 
Thanks!
Hey,
Thx for your comment.
I’m thinking of the following:
→ Having two datatypes: (a) field value and (b) tables
(a) does retrieve one exact value from a sql source table matching unlimited filter criteria (being stored in various cells of any sheet)
(b) retrieves the selected columns of a sql table matching unlimited filter criteria (being stored in various cells of any sheet)
e.g.
database table ‘customer’
open the data selector … chose field value option, select the database field ‘Name’ and put the filter criteria which is stored in cell A1 ‘Customer no’ fills cell B1 with the name.
add a filter criteria “sql” allowing to put sql statements e.g. in a cell you may select as a filter