Functions and Operators
DuneSQL extends a comprehensive suite of functions and operators facilitating a broad spectrum of operations on data, including arithmetic operations, string manipulation, and date-time computations, tailored to blockchain analytics needs.Functions and Operators
Dive into the extensive range of functions and operators in DuneSQL for data
manipulation and analysis.
Data Types
With support for standard data types and unique blockchain-specific types like varbinary for addresses and hashes, along with int256 and uint256 for large numeric values, DuneSQL is adept at handling the intricacies of blockchain data.Data Types
Explore the diverse data types in DuneSQL, designed to cater to the unique
requirements of blockchain data.
SQL Statement Syntax
Adhering to standard SQL syntax with clauses like SELECT, FROM, WHERE, DuneSQL enables complex queries for data retrieval and analysis while restricting data modification operations to preserve database integrity.Reserved Keywords
DuneSQL designates specific reserved keywords for internal functions, ensuring these are not used as identifiers, thus maintaining the engine’s operational integrity.Reserved Keywords
Familiarize yourself with the reserved keywords in DuneSQL to avoid
conflicts in query syntax.
Querying Capabilities
Although DuneSQL limits data modification commands to safeguard data integrity, it offers innovative solutions like query queries for creating views and tables, enhancing data analysis flexibility.Querying Queries
Utilize the query queries feature in DuneSQL to compensate for the
restricted ability to create views and tables, enriching data analysis
possibilities.