Documentation Index

sqlo documentation navigation.

📚 Documentation Structure

🚀 Getting Started

• Getting Started - Installation, basic usage, core concepts

📖 Query Types

• SELECT Queries - Complete SELECT functionality (WHERE, ORDER BY, LIMIT, DISTINCT, UNION, etc.)

• INSERT Queries - Single/batch inserts, INSERT IGNORE, ON DUPLICATE KEY UPDATE

• UPDATE Queries - UPDATE, SET, WHERE, LIMIT, ORDER BY

• DELETE Queries - DELETE, WHERE, LIMIT, ORDER BY, safety best practices

🔧 SQL Features

• JOIN Operations - INNER, LEFT, RIGHT, CROSS JOIN and performance optimization

• Condition Objects - Condition, ComplexCondition, AND/OR combinations

• Expressions & Functions - Raw SQL, Func, FunctionFactory, common functions

🎯 Find by Use Case

I want to…

• Query data → SELECT Queries

• Insert data → INSERT Queries

• Update data → UPDATE Queries

• Delete data → DELETE Queries

• Join multiple tables → JOIN Operations

• Build complex conditions → Condition Objects

• Use SQL functions → Expressions & Functions

• Write raw SQL → Raw SQL Expressions

🔗 Quick Links

Common Features

• Basic SELECT

• WHERE conditions

• JOIN tables

• Batch inserts

• Pagination

Advanced Features

• Complex conditions

• Subqueries

• UNION

• Index Hints

Security

• Parameterized queries

• SQL injection protection

• DELETE safety

🆘 Need Help?

1. Check examples - Each document contains rich code examples

2. Search docs - Use Ctrl+F to search for keywords

3. Check tests - tests/unit/ directory contains more use cases

4. Open an issue - If you find problems or have suggestions

---

Get started → Getting Started