cai-query 0.1.0

//! CAI Query - SQL parser and query engine
//!
//! Provides SQL-like query interface for CAI entries with support for:
//! - SELECT with WHERE, ORDER BY, LIMIT, GROUP BY
//! - SHOW TABLES - list available tables
//! - DESCRIBE table_name - show table schema
//! - Built-in functions: date_format, concat, length, upper, lower, substring, coalesce, now
//! - Function registry for extensible SQL functions
//!
//! # Example
//!
//! ```rust,no_run
//! use cai_query::{QueryEngine, sql};
//! use cai_storage::MemoryStorage;
//!
//! # async fn example() -> Result<(), Box<dyn std::error::Error>> {
//! let storage = MemoryStorage::new();
//! let engine = QueryEngine::new(storage);
//!
//! // Simple SELECT
//! let _results = engine.execute("SELECT * FROM entries LIMIT 10").await?;
//!
//! // Show tables
//! let _results = engine.execute("SHOW TABLES").await?;
//!
//! // Describe table
//! let _results = engine.execute("DESCRIBE entries").await?;
//! # Ok(())
//! # }
//! ```

#![warn(missing_docs, unused_crate_dependencies)]

pub use cai_core::Result;

mod error;
mod eval;
mod executor;
mod functions;
mod parser;

pub use error::{ColumnInfo, QueryError, QueryResult, SchemaInfo, SchemaQueryType};
pub use executor::{QueryEngine, QueryResultData};
pub use functions::{FunctionArg, FunctionRegistry};
pub use parser::{parse, QueryType};

/// Convenience function to execute a SQL query
///
/// # Example
///
/// ```rust,no_run
/// use cai_query::sql;
/// use cai_storage::MemoryStorage;
///
/// # async fn example() -> Result<(), Box<dyn std::error::Error>> {
/// let storage = MemoryStorage::new();
/// let _results = sql("SELECT * FROM entries", storage).await?;
/// # Ok(())
/// # }
/// ```
pub async fn sql<S>(query: &str, storage: S) -> QueryResult<Vec<cai_core::Entry>>
where
    S: cai_storage::Storage + 'static,
{
    QueryEngine::new(storage).execute(query).await
}