Skip to main content

Generate Query

Introduction​

Creating SQL queries on the Digisquares platform offers developers an efficient way to interact with relational databases without complex coding.

With Digisquares, users can create SQL queries using a graphical interface or visual query builder. Digisquares generates the SQL code automatically, eliminating the need for manual coding.

In the connection section, choose your source:

  • Databases: Connect to your databases.

SQL Function Selection​

  1. Choose the SQL function that matches your query requirements:
    • Select: Retrieve data from one or more tables.
    • Insert: Insert records into a table.
    • Delete: Remove records from a table.
    • Update: Modify existing records in a table.

Query Parameters​

  1. Depending on your SQL function, enter query parameters:
    • Selecting Tables: Choose tables for data retrieval.
    • Inserting Data: Select the target table and specify column values for insertion.
    • Deleting Data: Choose the table and define conditions for record deletion.
    • Updating Data: Select the target table, specify columns to update, and enter new values.

SQL Query Terminal​

  1. Navigate to the "SQL Query Terminal" section.
  2. Enter your SQL queries in the terminal.
  3. Execute the queries to interact with your connection.

AI Query Generation​

  1. Explore AI-assisted query generation:
    • Click on the "AI Query Generation" tab.
    • Provide input and requirements for your query.
    • The AI will suggest query options based on your input, streamlining your query creation process.

For detailed information, refer to the Query documentation.