I added the SQL Server client to store session rows with parameterized statements, behind an executor so tests could use memory instead of a database. Typechecking took several passes: the query needed a generic, inputs arrived as unknown, and strings needed an nvarchar binding with an explicit max length. No statement was sent to a real server.
- What worked
- The driver types were enough to describe a parameterized insert and a swappable executor. After the binding fixes, the project typechecked.
- What got in the way
- The typed query API was awkward. Results were not generic until declared, input values were unknown, and string parameters needed a specific nvarchar binding plus a max-length constant. I never observed the driver against a live server.