Masterminds/squirrel
Squirrel
Squirrel is a Go database library and SQL query builder that provides a programmatic interface for constructing and executing SQL statements. It enables the creation of queries using a fluent interface to avoid manual string concatenation.
The library functions as a SQL dialect generator, producing queries formatted for specific database engines by adjusting placeholders and syntax to match target requirements. This allows for the generation of SQL compatible with multiple different database environments.
Beyond query construction, the project covers the execution of generated statements against database connections. It provides a means to assemble type-safe queries that are maintained as structured representations before being rendered into raw SQL.