On Openblocks, you can build your web applications, internal management tools, as well as analyze data, tailor access for individual users or groups, and more. In all scenarios related to managing and manipulating databases, a query language is a crucial and efficient tool to perform corresponding operations, such as data retrieval, data update, database schema update, and data analysis. SQL is one of the most popular languages for interacting with databases.

Desperate to write SQL queries on different data sources?

When you are using multiple data sources for various business scenarios, there might be minor but important differences among SQL queries to read data from or write data to your databases. Below are two examples.

• String concatenation

  • MySQL uses concat() function

  • SQL Server uses the plus sign (+)

  • Oracle uses the vertical bar (||)

• Data type

  • MySQL uses single-precision (32-bit) floating point numbers.

  • SQL Server uses double-precision (64-bit) floating point numbers.

Let OpenAI facilitate you

It is time-consuming to remember all the details and to debug when a typo occurs. Is there any way to free you from keeping in mind the usage of SQL on different data sources, so that you can focus on the development and enhancement of your core business?

The powerful language model GPT-3 might be able to help. Trained with a huge amount of data, it is "knowledgeable" and is able to respond to your request in natural language. Besides the universally liked ChatGPT, OpenAI has also trained and released many other models. For instance, "code-davinci-001" and "code-davinci-002". Their training data includes both datasets in natural language and public code from GitHub. For more information, see Codex models.

Provide the model with short descriptions of the table and what your query is supposed to do in human language, then the model generates a query for you. This feature is especially helpful for newbies in databases. Additionally, OpenAI models accept user input via audio messages, making it even easier for certain cases.

Generate SQL queries on OpenAI

Suppose I'm working on a table in an app that I built on Openblocks. Now I'd like to filter items that meet two requirements:

• The value of "email" contains "gov".

• The value of "department" equals "Engineering".

Follow the steps to generate a SQL query that satisfies certain needs.

1. Sign up for an OpenAI account.

2. Log in on OpenAI and go to the Playground page.

3. Select a model in the settings pane.

4. Describe your scenario and demand in the text box.

5. Click Submit.

6. Copy paste the query into your workspace. For instance, the query editor on Openblocks.

The OpenAI-generated query works well. Try it on your own and see how it could help.

What's next?

Openblocks is an open-source low-code platform where you can find 50+ built-in components. It also offers excellent documentation to discuss technical details, present practical tutorials, and provide all the information you need know for building an app. On Openblocks, you can get connected to most databases and any API within clicks, design custom components, share apps with colleagues or customers, and more.

Start your first app now and feel free to reach the vibrant community on Discord if you encounter any issue or would like to share an idea!