There's a nuget package linked, so I'm guessing this is achieved via some kind of tight coupling with a clever db client library

It's a. Net client side only library