次の表は、DuneSQLで予約されているすべてのキーワードと、それらのSQL標準におけるステータスを一覧にしたものです。これらの予約済みキーワードは、識別子として使用するためには二重引用符(")で囲む必要があります。

例えば、特定のアドレスからのすべてのトランザクションをtransactionsテーブルからクエリするには、fromを二重引用符で囲んで次のようにクエリを実行します:

Select * from ethereum.transactions
where "from" = 0xc8ebccc5f5689fa8659d83713341e5ad19349448

予約語

Keyword SQL:2016
ALTER reserved
AND reserved
AS reserved
BETWEEN reserved
BY reserved
CASE reserved
CAST reserved
CONSTRAINT reserved
CREATE reserved
CROSS reserved
CUBE reserved
CURRENT_CATALOG reserved
CURRENT_DATE reserved
CURRENT_PATH reserved
CURRENT_ROLE reserved
CURRENT_SCHEMA reserved
CURRENT_TIME reserved
CURRENT_TIMESTAMP reserved
CURRENT_USER reserved
DEALLOCATE reserved
DELETE reserved
DESCRIBE reserved
DISTINCT reserved
DROP reserved
ELSE reserved
END reserved
ESCAPE reserved
EXCEPT reserved
EXECUTE reserved
EXISTS reserved
EXTRACT reserved
FALSE reserved
FOR reserved
FROM reserved
FULL reserved
GROUP reserved
GROUPING reserved
HAVING reserved
IN reserved
INNER reserved
INSERT reserved
INTERSECT reserved
INTO reserved
IS reserved
JOIN reserved
JSON_ARRAY reserved
JSON_EXISTS reserved
JSON_OBJECT reserved
JSON_QUERY reserved
JSON_VALUE reserved
LEFT reserved
LIKE reserved
LISTAGG reserved
LOCALTIME reserved
LOCALTIMESTAMP reserved
NATURAL reserved
NORMALIZE reserved
NOT reserved
NULL reserved
ON reserved
OR reserved
ORDER reserved
OUTER reserved
PREPARE reserved
RECURSIVE reserved
RIGHT reserved
ROLLUP reserved
SELECT reserved
SKIP reserved
TABLE reserved
THEN reserved
TRIM reserved
TRUE reserved
UESCAPE reserved
UNION reserved
UNNEST reserved
USING reserved
VALUES reserved
WHEN reserved
WHERE reserved
WITH reserved