Every database vendor like Oracle, MSSQL, PostgreSQL, MySQL, and H2,… speaks the same principal language SQL with a lot of hues specific to each implementation forming a dialect. Like all of them, SQL Cloud has supports its own dialect.
Furthermore, the SQL Cloud engine has some other major differences compared to the rest about how it works, known as constraints.
You must know the dialect and the constraints in order to write queries in SQLC SQL Cloud successfully. Otherwise, you might fall frustrated in frustration and wrongly conclude that the app does not work properly due to your misunderstanding, even if you are the more experienced user in SQL.