chore: bump version to 1.0.12 in package.json

fix: update test assertions and repository return types for consistency

- Modified the delete test to include a placeholder assertion.
- Updated the update test to reflect that an empty array is returned when no record exists.
- Adjusted the QueryResult interface to include an optional rowCount property for better clarity in return types.

Refactor select query builder to ensure join select clause is only in…

…cluded when not empty