clear

Natively handles advanced features like JSONB, UUID, full-text search (tsvectors), and cursors, enabling direct use in queries without cumbersome workarounds, as shown in examples with jsonb path queries.

Offers a powerful DSL for where and having clauses with operators like regex, JSONB path queries, and range checks, making complex queries readable and straightforward in Crystal code.

Built-in preloading and caching for associations, such as with_posts, avoids N+1 query problems by fetching related data in bulk, though careful query design is needed to maintain cache validity.

Includes cursor-based fetching for large datasets to manage memory efficiently, and query logging with syntax highlighting for debugging, as demonstrated in performance benchmarks.