Home
/
Cryptocurrency news
/
Blockchain technologies
/

New sql engine lets you query any evm event instantly

New SQL Engine Empowers EVM Data Analysis | No More Waiting for Indexed Contracts

By

Liam Johnson

Mar 10, 2026, 12:11 PM

2 minutes estimated to read

Illustration showing a SQL engine with blockchain icons and event data streams

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.

The Challenge of 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."

How the New SQL Engine Works

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.

A Look at Accessibility and User Experiences

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.

Key Features Highlighted

  • 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.

Key Takeaways

  • πŸš€ 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?

Future Outlook for EVM Data 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.

Historical Echoes of Rapid Change

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.