This section is not intended to be a course of the SQL language. Therefore, the focus will be put on the minimal set of differences that you must know in order to write queries properly.

...

SQL Cloud is a 100% JavaScript database ruining running on the browser (Chrome, Safari, Edge, Firefox…) and any device (PC, tablet, mobile..). The engine and the full data model (tables, indexes, etc.) are created when the page is loaded and it everything is fully destroyed when the page is closed. The tables are empty and populated in real-time fetching data over the Atlassian’s Jira public REST API to answer the users' queries.

...

Expand
title Example
Code Block language sql select * from PROJECT will work. Whereas Code Block language sql select * from project will not.

KEY is a reserved word

As other database vendors, SQL Cloud does have reserved words that must be surrounded with accents or square brackets

...

SELECT `i`.`KEY`as `Issue`, count(*) as `Num. comments`
FROM ISSUE `i`
LEFT JOIN ISSUECOMMENT `ic` ON `ic`.`ISSUEID` = `i`.`ID`
WHERE `i`.`JQL` = 'PROJECT = TALH'
GROUP BY `i`.`KEY`
HAVING count(*) > 2

SELECT `i`.`KEY`as `Issue`, count(*) as `Num. comments`
FROM ISSUE `i`
LEFT JOIN ISSUECOMMENT `ic` ON `ic`.`ISSUEID` = `i`.`ID`
WHERE `i`.`JQL` = 'PROJECT = TALH'
GROUP BY `i`.`KEY`
HAVING `Num. comments` > 2