Struct SqliteProjectionGenerator 

pub struct SqliteProjectionGenerator { /* private fields */ }

SQLite SQL projection generator.

SQLite’s JSON support is more limited than PostgreSQL and MySQL. Uses json_object() with json_extract() to project fields.

Example

use fraiseql_core::db::projection_generator::SqliteProjectionGenerator;

let generator = SqliteProjectionGenerator::new();
let fields = vec!["id".to_string(), "name".to_string()];
let sql = generator.generate_projection_sql(&fields).unwrap();
assert!(sql.contains("json_object"));

Implementations

impl SqliteProjectionGenerator

pub fn new() -> Self

Create new SQLite projection generator with default JSON column name.

Default JSON column: “data”

pub fn with_column(json_column: &str) -> Self

Create projection generator with custom JSON column name.

Arguments

• json_column - Name of the JSON column in the database table

pub fn generate_projection_sql(&self, fields: &[String]) -> Result<String>

Generate SQLite projection SQL for specified fields.

Generates a json_object() call that selects only the requested fields.

Arguments

• fields - JSON field names to project

Returns

SQL fragment that can be used in a SELECT clause

Trait Implementations

impl Default for SqliteProjectionGenerator

fn default() -> Self

Returns the “default value” for a type.