Custom SQL allows users to extend the functionality of the platform by writing their own SQL queries. This section will guide you through the process of creating and executing custom SQL queries.

Overview

  • Purpose: Custom SQL is used to perform complex data manipulations that are not covered by the standard query capabilities.
  • Use Cases: Analyzing large datasets, performing calculations, and extracting specific information from the database.

Getting Started

  1. Accessing the Custom SQL Editor:

    • Navigate to /en/docs/custom_sql_editor for the editor interface.
    • Here, you can write, test, and execute your SQL queries.

  2. Writing Your SQL Query:

    • Start with a clear understanding of the data structure and relationships.
    • Use the SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses to construct your query.

  3. Executing the Query:

    • Once you have written your query, click the "Execute" button.
    • Review the results and make adjustments as necessary.

Example

Suppose you want to find the total sales for each region in the last quarter. You could write a query like this:

SELECT region, SUM(sales) as total_sales
FROM sales_data
WHERE sale_date >= '2023-07-01' AND sale_date <= '2023-09-30'
GROUP BY region;

Best Practices

  • Use Comments: Document your queries to make them easier to understand for others.
  • Test Thoroughly: Always test your queries with a subset of data before running them on the entire dataset.
  • Performance: Be mindful of the performance implications of your queries, especially when working with large datasets.

Database Query Example

For more information on SQL and database management, check out our SQL Basics Guide.

If you encounter any issues or have questions about custom SQL, don't hesitate to reach out to our support team at /en/docs/support.