What problem does it solve? Creating a view in a Thinkwise Software Factory model involves a long, error-prone chain of metadata objects — the tab entity, columns, domains, references, control procedures, templates, and program object assignments — where mistakes like wrong dialect SQL, reversed reference direction, or skipped code generation only surface silently. This Skill guides the full lifecycle so views are modeled, coded, generated, and verified correctly the first time. ## Core Features & Use Cases - End-to-end view creation workflow: Covers tab setup with type_of_table = view, column modeling with grain-based primary keys, domain reuse from source tables, and reversed-direction references for view columns. - Template-based SELECT authoring: Guides writing the control procedure template in the correct RDBMS dialect (checked via branch_rdbms_type), wiring it via template_prog_object_item, and generating code with task_generate_code_grp and task_add_job_to_generate_object_code. - Ad hoc query conversion: Converts a user's working SQL query into a properly modeled view, confirming source tables against the live model and diffing the generated SQL against the original query. - Use Case: A user pastes a SQL Server query from SSMS and asks to turn it into a view; the Skill walks through confirming grain and primary key, modeling columns with reused domains, writing a dialect-correct template, generating the view_<tab_id> program object, and verifying the output matches the original query. ## Quick Start Ask the AI to create a view in your Thinkwise Software Factory model from a SQL query or business question, and it will follow this Skill to model, code, generate, and verify it.
