I want to write sql but have my library map between my languages built-in types and my sql types. I feel like something like Dapper is the correct abstraction f

I want to write sql but have my library map between my languages built-in types and my sql types. I feel like something like Dapper is the correct abstraction for communicating with a database.