次の表は、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 |