search

amphi-ai / amphi-etl

Visual Data Transformation with Python Code Generation. Low-Code Python-based ETL.
https://amphi.ai
Other
893 stars 43 forks source link

SQL Query help button should indicate example of queries such as set #80

Open simonaubertbd opened 2 months ago

simonaubertbd commented 2 months ago

Hello,

I managed to add "set" commands to my postgresql input tool. Not difficult, but not intuitive and I think the "help" should indicate that you can do that (contrary to most of software where you have a dedicated place to do so)

image

of course, it's true for any database input tool.

Best regards,

Simon

tgourdel commented 2 months ago

Thanks Simon, very good points. I need to check this further, I'll take a look at how it's done elsewhere. Indeed you can write any SQL in the SQL Query field as long as it returns data.