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
Optional EmbeddingThe AI Model ID used to generate the embedding vector for this query. Required for vector similarity comparisons.
Optional EmbeddingThe name of the AI Model used to generate the embedding vector for this query.
Optional EmbeddingOptional JSON-serialized embedding vector for the query, used for similarity search and query analysis
Optional EntitiesEntities referenced by this query
Field metadata for this query
Unique identifier for the query record
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
The actual SQL query text to execute, may include Nunjucks template parameters
Current status of the query in the approval workflow
Complete metadata about a stored query, including its SQL, approval status, quality ranking, and field definitions. This information allows Skip to understand and utilize pre-built queries for analysis and reporting.
Implements IQueryInfoBase for consistency with MJCore types.