v1.0.0

Release Notes: SQL Generator v1.0.0

🚀 Initial Release: T4-based SQL Query Generator

Overview

This first release introduces a robust T4 template solution for automated SQL query generation with customizable parameters. The tool simplifies database scripting by programmatically creating properly formatted SELECT statements.

✨ Key Features

• Configurable Generation
  Set number of tables (N) and fields (M) via simple constants

• Intelligent Validation
  Built-in checks ensure valid configurations (N ≤ M)

• Clean Output
  Generates well-formatted SQL with:

  • Automatic table/field numbering (Table_1, Field_1)
  • Section headers/footers
  • Generation timestamp

• Extensible Architecture
  Modular SqlGeneratorHelper class for easy maintenance

🛠 Usage

1. Modify constants in SqlGenerator.tt:

   const int N = 3; // Number of tables  
   const int M = 5; // Available fields

2. Save to auto-generate SqlGenerator.sql

📦 Included Files

• SqlGenerator.tt - Main T4 template
• README.md - Documentation
• Sample output .sql file

🚨 Known Limitations

• Currently generates only basic SELECT statements
• Field/table naming follows simple sequential pattern

🔜 Future Roadmap

• Support for INSERT/UPDATE statements
• Custom naming patterns
• Database-specific syntax options

Contributions welcome! 🎉

Release Date: 2025-04-15
Version Compatibility: Visual Studio 2017+