Struct ChainQueryBuilder 

pub struct ChainQueryBuilder { /* private fields */ }

Builder for chain SQL queries.

Uses the SearchParameterRegistry to resolve target types for reference parameters and generates efficient SQL subqueries.

Implementations

impl ChainQueryBuilder

pub fn new( tenant_id: impl Into<String>, base_type: impl Into<String>, registry: Arc<RwLock<SearchParameterRegistry>>, ) -> Self

Creates a new chain query builder.

pub fn with_config(self, config: ChainConfig) -> Self

Sets the chain configuration.

pub fn with_param_offset(self, offset: usize) -> Self

Sets the parameter offset for SQL placeholders.

pub fn parse_chain(&self, chain_str: &str) -> Result<ParsedChain, ChainError>

Parses a chain string into structured chain links.

Arguments

• chain_str - The chain path (e.g., “subject.organization.name” or “subject:Patient.name”)

Returns

A ParsedChain with resolved types, or an error if parsing fails.

pub fn build_forward_chain_sql( &self, chain: &ParsedChain, value: &SearchValue, ) -> StorageResult<SqlFragment>

Builds SQL for a forward chain query.

Generates nested subqueries that efficiently resolve the chain using the search_index table.

Example Output

For Observation?subject.organization.name=Hospital:

r.id IN (
  SELECT si1.resource_id FROM search_index si1
  WHERE si1.tenant_id = ?1 AND si1.resource_type = 'Observation'
    AND si1.param_name = 'subject'
    AND si1.value_reference IN (
      SELECT 'Patient/' || si2.resource_id FROM search_index si2
      WHERE si2.tenant_id = ?1 AND si2.resource_type = 'Patient'
        AND si2.param_name = 'organization'
        AND si2.value_reference IN (
          SELECT 'Organization/' || si3.resource_id FROM search_index si3
          WHERE si3.tenant_id = ?1 AND si3.resource_type = 'Organization'
            AND si3.param_name = 'name'
            AND si3.value_string LIKE ?3
        )
    )
)

pub fn build_reverse_chain_sql( &self, reverse_chain: &ReverseChainedParameter, ) -> StorageResult<SqlFragment>

Builds SQL for a reverse chain (_has) query.

Generates subqueries that find base resources referenced by resources matching the search criteria.

Example Output

For Patient?_has:Observation:subject:code=1234-5:

r.id IN (
  SELECT SUBSTR(si1.value_reference, INSTR(si1.value_reference, '/') + 1)
  FROM search_index si1
  WHERE si1.tenant_id = ?1 AND si1.resource_type = 'Observation'
    AND si1.param_name = 'subject'
    AND si1.value_reference LIKE 'Patient/%'
    AND si1.resource_id IN (
      SELECT si2.resource_id FROM search_index si2
      WHERE si2.tenant_id = ?1 AND si2.resource_type = 'Observation'
        AND si2.param_name = 'code'
        AND si2.value_token_code = ?3
    )
)