v2.21.0
New Features
AI Models: Supported Response Formats
- Introduced the
SupportedResponseFormatsfield for AI Models, allowing specification of response formats such asAny,Text,JSON,Markdown, orModel Specific. This enhancement provides flexibility for future expansions.
AI Prompts: Response Format Specification
- Added the
ResponseFormatfield to AI Prompts, enabling users to define desired response formats aligned with the supported formats of the selected AI model. - Implemented the
ModelSpecificResponseFormatfield (nvarchar(max)) to accommodate custom JSON schemas for structured outputs, supporting models like OpenAI and Google.
BaseLLM Enhancements
- Updated
BaseLLMto support the new response format features. Subclasses for providers supporting JSON mode (e.g., OpenAI, Groq) have been configured accordingly for immediate use.
Entity Metadata: New Columns
-
ScopeDefault: Introduced a column with optionsUsers,Admins,AI,All, or any combination thereof (comma-delimited). Entities withAllorAIin this field are processed accordingly. -
RowsToPackWithSchema: Added a column to specify data packing preferences with optionsNone,All, orSample. For "type tables," setting this toAllincludes all rows; for others,Samplecan be used to include a subset. -
RowsToPackSampleMethod: Defined methods (random,top n,bottom n) to select rows when RowsToPackWithSchema is set toSample. -
RowsToPackSampleCount: Specified the number of rows to include in the sample. -
RowsToPackSampleOrder: Determined the ordering of rows for sampling, allowing sorting (e.g., byOrderDate DESC) before selecting the top N rows.
Entity Field Metadata Additions
-
ScopeDefault: Applied at the field level to refine data inclusion, enabling exclusion of unnecessary columns.
-
AutoUpdateRelatedEntityInfo: A boolean field (defaulting to true) controlling whether CodeGen updates the
RelatedEntityIDandRelatedEntityFieldNamecolumns. For schemas lacking foreign keys, setting this to false allows manual configuration, providing essential relationship information. -
ValuesToPackWithSchema: An attribute with options
All,None, orAuto(default).Autoincludes associated value lists;Allruns aDISTINCTquery to gather the full range of underlying table values, enhancing model query capabilities.
Entity Relationship Metadata
- AutoUpdateFromSchema: Introduced a boolean field (defaulting to true). Setting this to false grants manual control over relationship records, complementing the above features.
Skip Integration
- To utilize these enhancements in Skip, upgrade to the upcoming 2.21.0 build. Update prompts to enable JSON as needed, and ensure the new metadata is passed into BaseLLM calls.
