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.

A pure JavaScript database

SQL Cloud is a 100% JavaScript database ruining on the browser (Chrome, Safari, Edge, Firefox…) and any device (PC, tablet, mobile..). The full data model (tables, indexes, etc.) are created when the page is loaded and it 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.

Show tables and columns

• show tables

• show columns from <table>

...

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