Interface IQueryInfoBase

When true, query results will be cached in memory with TTL expiration

Maximum number of cached result sets for this query. NULL uses default size limit.

Time-to-live in minutes for cached query results. NULL uses default TTL.

SQL query that returns cache validation fingerprint data (MaxUpdatedAt, RowCount). Used for smart cache refresh to determine if cached data is stale.

Category name from the related Query Categories entity

Foreign key reference to the Query Categories entity

Full hierarchical path of the category (e.g., "/MJ/AI/Agents/")

Detailed description of what the query does and what data it returns

The AI Model ID used to generate the embedding vector

The AI Model name used to generate the embedding vector

Optional JSON-serialized embedding vector for similarity search

Entities referenced by this query

Field metadata for this query

Unique identifier for the query record

Whether this query has been formally approved for production use. Derived from Status === 'Approved'.

Name of the query for display and reference

Parameter definitions for this parameterized query

Value indicating the quality of the query, higher values mean better quality

When true, this query can be referenced by other queries via the composition syntax {{query:"CategoryPath/QueryName"}}. Only queries with Reusable=true AND Status='Approved' are eligible for composition.

The actual SQL query text to execute, may include Nunjucks template parameters

Foreign key to the SQL dialect this query's SQL column is written in. Defaults to T-SQL for backward compatibility.

Current status of the query in the approval workflow

Technical documentation of the query logic, performance considerations, and parameter usage. Supports markdown content including mermaid diagrams.

Automatically set to true when the SQL column contains Nunjucks template markers like {{paramName}}