Exportable libraries for embedding sqlc functionality in other cli apps

[clintberry]

Sometimes larger companies have their own tool chains including custom CLI apps for generating new projects, etc. I would love to add sqlc functionality to our custom CLI app, but most of the tool chain is behind the internal folder. A good example of a CLI tool but that can also be easily embeddable in other projects is the Goose db migrations tool: https://github.com/pressly/goose

Are you opposed to me just forking the project and messing around with the structure a bit to see if I could get it to fit in our custom tool chain?

An example of something we would want to explore doing at Weave: We start with a proto definition that defines the data model, so I want to generate the sqlc functions to use the proto generated model instead of generating its own (I actually have this working as a POC but it is a hack).

[kyleconroy]

I would love to add sqlc functionality to our custom CLI app, but most of the tool chain is behind the internal folder.

The reason for this is that I don't want others depending on the internal types and methods that power sqlc. They aren't solidified and shouldn't be used publicly. That said, I'm happy to expose an interface that mirrors the command line tool.

Are you opposed to me just forking the project and messing around with the structure a bit to see if I could get it to fit in our custom tool chain?

Nope! Excited to see what you come up with.

[phamdt]

i'm also interested in exported functions. however, in my case, i'd want to include it in an open source tool to allow users to generate code more granularly anywhere they want. for example, if they wanted to take a single sql statement and generate a test using their preferred test libraries, they could do so but would need the SQL to be validated and some data structure representing the SQL.

[bbkane]

@clintberry , did anything come of this? I'm interested in the same functionality and it'd be super nice if you already did most of the work :)

[kyleconroy]

esbuild exposes an api package that mirrors the CLI tool. If there's still appetite for this, I may work on a similar package. As I said previously, this would not expose any of the sqlc internals.