Have you ever thought about using SQL in Baserow?

[anon7289648]

cases

case 1

1. “You cannot directly query an Airtable table, but you can use a view to accomplish the same goal. The best way to think about translating queries to Airtable is that each view contains (roughly) the output of a query on a single table.”

   • It would be a differential in Baserow, since Airtable does not offer this option.

case 2

2. For example, in my case I know SQL and I wanted to do some sql queries in Baserow. This is very useful for people who have knowledge of databases, but use a no-code application.

references

• https://support.airtable.com/hc/en-us/articles/1500006246961-Can-I-create-a-SQL-query-in-Airtable-
• Airtable SQL Server Integration: 3 Easy Methods - Learn | Hevo

[petrs]

What would be the use case?

Creating a view programmatically in SQL and not through UI?

Is there something that can’t be done through the UI? Or you think it would be quicker with a query builder?

[petrs]

If you self-host Baserow, you can always easily query the PostgreSQL database anyways.

[anon7289648]

@petrs

Or you think it would be quicker with a query builder?

• Yeah, In this case… query builder.

[petrs]

We don’t have any real plans on introducing a query builder in Baserow, sorry! Our focus is more on a “no-code” interface where users don’t have to think about the database joins and so on.