Open creates an ent client connected to the SQLite database at dbPath.
The database is configured with WAL journal mode, foreign key enforcement,
and a 5-second busy timeout. It returns both the ent client and the
underlying *sql.DB for raw SQL operations (e.g., sync_status table).