sqler

1.2.1

• Fixed #24 issue of unscaped string in QVar for sqlite
• Fixed reports of dart analyze.
• Update dependencies

• Fixed #24 issue of unscaped string in QVar for sqlite
• Fixed reports of dart analyze.
• Update dependencies

• Sqler().toSQL<Sqlite>()

• BREAKING CHANGE: Renamed mysql_query.dart to sql_query.dart and mysql_model.dart to sql_model.dart for better generic SQL support
• NEW: Added SQLite support alongside existing MySQL functionality
• NEW: Introduced generic SQL types (Mysql and Sqlite) for database-specific SQL generation
• NEW: All toSQL() methods now accept a generic type parameter to generate database-specific SQL
• NEW: Added SQLite-specific field types (INTEGER, REAL) in FieldTypes enum
• NEW: Proper quotation handling - backticks for MySQL, double quotes for SQLite
• NEW: SQLite-compatible auto-increment syntax (AUTOINCREMENT vs AUTO_INCREMENT)
• NEW: Added sqlite3 dependency for SQLite testing support
• IMPROVED: Updated all test cases to validate both MySQL and SQLite SQL generation
• IMPROVED: Enhanced MFieldInt to automatically use correct integer type based on target database
• IMPROVED: Modified all SQL component classes to extend SQL instead of implementing it
• IMPROVED: Better abstraction for cross-database compatibility while maintaining existing API

• Added add() and clear() methods to the Where class.
• Added allSelectFields() function to MTable to generate a list of all columns for selection.
• Added whereAnd, whereOr, and whereOne methods to the Sqler class.
• Added OnOne method to summarize On when there is only one.
• Added Sqler as a new value for QVar to allow using the Sqler class as a value in conditions.

• Fixed table name for JOIN's #23, #21

• Password QVar QVar.password('test', hashType: HashType.sha1) support sha1, md5(default), sha256, sha512, HMAC-SHA256
• SqlExplain class able to generate EXPLAIN details from other SQL. SqlExplain(sqlerQuery).toSQL()

• Added DISTINCT for QField #16
• Improve the Aggregate Functions #1
• Added Validator functionalty for input variables in MField and MTable

• Added MTable and MField classes for table and field abstraction.
• Implemented SQL generation for CREATE TABLE statements.
• Improved code structure for easier table definition and management.

• Initial version.