search

PipedreamHQ / pipedream

Connect APIs, remarkably fast. Free for developers.
https://pipedream.com
Other
8.83k stars 5.27k forks source link

[ACTION] support getSchema and executeQueryAdapter in additional apps #12647

Closed dannyroosevelt closed 2 months ago

dannyroosevelt commented 3 months ago

We recently released support for a first-class SQL editor and schema explorer for certain database apps.

To extend these features to additional database types, we need to add support for the getSchema and executeQueryAdapter methods in app file for any new apps we want to support. See here for more info: https://pipedream.com/docs/components/guidelines#database-components

We should add support for these methods in these apps: [] supabase [] microsoft_sql_server [] azure_sql

Then create a generic "Execute SQL Query" action for each of those apps, similar to https://github.com/PipedreamHQ/pipedream/blob/master/components/postgresql/actions/execute-custom-query/execute-custom-query.mjs

Garvitpant777 commented 3 months ago

can i work on this?

malexanderlim commented 3 months ago

@Garvitpant777 , this issue is already assigned to one of our component developers. You are welcome to work on a different PR as you see fit though!

vunguyenhung commented 2 months ago

Hi everyone, all test cases are passed! Ready for release!

Test report https://vunguyenhung.notion.site/ACTION-support-getSchema-and-executeQueryAdapter-in-additional-apps-f82196c342cb4c1e97589eaa7e19eaf0

vunguyenhung commented 2 months ago

Note: I did not see changes for Supabase. Though all other changes are passed!