Define my own interpolator

Hi, I really like Doobie, good work!

But I would like to define my own interpolator. In particular I was considering to:

1. Allow variables anywhere in the query, and use ?$ for the variables that need to be replaced with ? (just reading the last character in the previous fragment), this should allow using variables for table names, if I'm not mistaken
2. Have a default transactor in the same class where the interpolator is defined to execute the ConnectionIO into a Future with the results.

I was trying to use all the Doobie goodies for execution of the queries, type conversion, etc. But you are very clever and I can barely understand your code 😅

Is there any way to not use the sql interpolator but use the Doobie API directly? I have probably read the relevant code, but I cannot find a way to use it.

Thank you!

The request centers on Doobie's SQL interpolator and direct Doobie API; start by tracing the interpolator and the API used to execute ConnectionIO. Determine whether custom interpolation, variables in arbitrary query positions, and a default transactor are supported, and document the supported path or the required design decisions.