Connect to PostgreSQL from Visual Studio Code?

I have started putting together a C# asp .Net Core REST web API using SQLite for a simple start. I like the way it goes, but want to try out postgresql, as it has JSON support.
However I am not able to find a library/extension to make queries…. I find “management” extensions and tutorials, that let connect and view pgsql from visual code, but not to query db from code. The only library that looks like what I need is “npgsql”. But looks like it is only available in visual studio, not in visual code. Is it possible that there are no extensions for visual code and postgresql?