In general, MindsDB SQL attempts to follow the syntax conventions of MySQL and PostgreSQL. The following sections describe some common conventions of MindsDB SQL.

​
Notation

We adopt the following notation to describe our commands:
  • Reserved words are capitalized. For example: SELECT
  • Square brackets [] indicate optional clauses
  • Curly brackets {} indicate logical or choices with the options separated by |. For examples {x | y | z}
  • Red denotes required clauses, choices, or identifiers. For readability, statements enclosed in red square or curly brackets are black.
  • Square brackets with a separator followed by three ellipses denote repetition of the previous item, separated by the separator. For example, identifier [, ...] denotes a comma separated list of identifiers.
Parentheses () are reserved characters of the MindsDB SQL and are not part of the notation. Where present parentheses are required unless explicitly wrapped in square brackets.

​
Single/Double Quotes & Backticks

Identifiers (databases, tables, and column names) with special characters or reserved words must be enclosed with backticks ”`”: 
SELECT * FROM `select` WHERE `select`.id > 100;

SELECT * FROM `select-DATABASE` WHERE `select-DATABASE`.id > 100;
String values are represented by single and double quotes: 
SELECT * FROM table_name WHERE table_name.column_name = 'string';
SELECT * FROM table_name WHERE table_name.column_name = "string";

​
Parentheses

SQL statements can be nested with parentheses: 
SELECT * FROM (SELECT * FROM table_name WHERE table_name.column_name = 'string') ;