Edited By
Fatima El-Sayed

A new SQL engine that simplifies querying EVM events from any contract emerges as a promising solution for blockchain analysts. Previously restricted to pre-decoded tables, this innovative tool eliminates the bottleneck of waiting for contract indexing, offering instant access to crucial on-chain data.
Blockchain analysts often face considerable frustration when attempting to analyze specific contracts that arenβt indexed. Traditional platforms rely on manually curated tables, making it difficult for analysts to access the vital data they need. One user expressed, "Every time we needed data from a new contract, we hit the same bottleneck."
This new engine adopts a Bring Your Own ABI (BYOABI) approach:
Raw event logs storage across EVM chains
Dynamic decoding using user-provided ABI in queries
Structured results returned immediately, no waiting required.
"No dependencies on someone else indexing your contract first!"
Analysts can now use SQL (specifically ClickHouse syntax) directly for queries. This allows them to easily work with Solidity types and access a full array of SQL functionalities, which can enhance their analytical capabilities.
Supported chains include Ethereum, Arbitrum, Base, Polygon, and others. Users have reacted positively, with comments highlighting how easily one can access billions of events with just three clicks.
"This is so cool! You guys are doing good for web3," said a satisfied user.
Another called it "a good idea," noting its potential to simplify blockchain analytics further.
User-Friendly Query Builder: Designed for both humans and automated agents.
Fast Access: Navigate billions of events efficiently, bypassing traditional indexing delays.
Broad Compatibility: Works with various EVM chains, expanding analytical horizons.
π Users can expect immediate access without waiting for indexing.
π BYOABI lets analysts use their preferred ABI for custom queries.
π Feedback indicates strong community support, with many praising its ease of use.
As the crypto landscape continues to evolve, tools like this SQL engine may redefine how analysts interact with blockchain data. Is this the key to unleashing the full potential of EVM analytics?
There's a strong chance that the rise of this SQL engine will encourage further innovation in EVM data querying methodologies. Analysts will likely push for additional features, enhancing automation and increasing compatibility across more chains. Experts estimate around 70% of blockchain analysts will adopt such tools within the next year, as the demand for real-time insights surges. As the technology matures, we might see integrations with machine learning, allowing deeper, predictive analyses of blockchain data trends, setting a new precedent for web3 analytics.
The rapid adaptation to this SQL engine mirrors the advent of personal computers in the late '70s. Just as individuals transitioned from bulky mainframes to user-friendly machines that empowered personal creativity, todayβs blockchain analysts are breaking free from outdated indexing constraints. This technology could shift the landscape of data analytics, much like PCs transformed how we process and share information. Just as the early adopters revolutionized computing, todayβs blockchain experts using this SQL engine could reshape how we understand and utilize on-chain data.