Guides

Task-oriented guides for working with GIQL. These guides cover common workflows and best practices for using GIQL effectively.

• Schema Mapping Guide
  • Understanding Schema Mapping
  • Registering Table Schemas
  • Multiple Tables
  • Coordinate Systems
  • Data Types
  • Loading Data
  • Troubleshooting
• Multi-Backend Guide
  • Supported Backends
  • Selecting a Backend
  • Backend Configuration
  • Writing Portable Queries
  • Migrating Between Backends
  • Performance Comparison
  • Using External Connections
• Performance Guide
  • Understanding Query Performance
  • Indexing Strategies
  • Query Optimization Patterns
  • NEAREST Query Optimization
  • Merge and Cluster Optimization
  • Analyzing Query Performance
  • Backend-Specific Tips
  • Memory Management
  • Performance Checklist
• Transpilation Guide
  • How Transpilation Works
  • Using the Transpile Method
  • Debugging with Transpilation
  • Comparing Dialects
  • Using Transpiled SQL Externally
  • Advanced Transpilation

Guide Overview

Schema Mapping Guide

Learn how to configure GIQL to work with your genomic data, including registering table schemas and mapping logical genomic columns.

Multi-Backend Guide

Understand GIQL’s multi-database support and how to work with different backends like DuckDB, SQLite, and PostgreSQL.

Performance Guide

Optimize your GIQL queries for better performance with indexing strategies, query patterns, and backend-specific tips.

Transpilation Guide

Understand how GIQL translates queries to SQL, debug query generation, and integrate transpiled SQL with external tools.