SQL custom queries

Budibase supports the ability to write custom queries. These queries can be really useful if you want to not just fetch single table (rows).

Writing these queries is quite straightforward. Head over to your data source, and scroll down until you find the queries section. Click the Add Query button, which will guide you to a form to configure your query.

An example would be to query all pet names from a specific owner. For this demonstration we've used a custom binding to insert the ownerID into the query.

Using query bindings

You can also override the default binding values.

When you use the query as a data source for your provider, you can click on the cog icon.

This will show a query bindings drawer where you can add a dynamic value to override the default.

Editing custom queries

A list of your custom queries can be found underneath the associated data sources. Click on the query to be able to edit the config.

It is also possible to delete queries that are no longer needed, or duplicate queries, which can useful in cases where an additional query only requires minor changes.

To access these options, hover over the query and click the

Did this page help you?