This patch resolves several critical bugs and adds missing functionality:

**Critical Bug Fixes:**

1. **core.Model Scanning Issues (High Severity)**
   - Fixed scanning errors when using structs with embedded core.Model
   - Implemented fieldPath system to correctly navigate through embedded structs
   - Impact: All queries with models using core.Model now work correctly
   - File: query/scanner.go

2. **AutoMigrate SQLite Syntax Error (High Severity)**
   - Fixed incorrect MySQL AUTO_INCREMENT syntax being used for SQLite
   - Implemented dialect detection based on Placeholder() and QuoteIdentifier()
   - PostgreSQL: SERIAL, MySQL: AUTO_INCREMENT, SQLite: INTEGER (auto)
   - Impact: AutoMigrate now works correctly on SQLite
   - File: migrate/auto.go

3. **Migrations Table Type Issues**
   - Fixed generic SQL types in createMigrationsTable
   - Implemented dialect-specific types (BIGINT vs INTEGER, TIMESTAMP vs DATETIME)
   - Impact: Migration system works correctly across all supported dialects
   - File: migrate/migrate.go

**Added:**
- core.ErrValidation error that was missing
- Float64Field for non-nullable float64 columns
- SQL driver dependencies (lib/pq, go-sql-driver/mysql, mattn/go-sqlite3)

**Fixed - Examples:**
- Updated examples to use correct API (genus.NewWithLogger, g.DB().Create, etc)
- Fixed redundant newlines in fmt.Println statements

All tests passing. Ready for v1.0.1 release.