Question 1

How do I build dynamic WHERE clauses with conditions that change at runtime in sqlf?

Accepted Answer

Use the `.Where()` method to add conditions programmatically—you can chain multiple calls or use conditional logic based on variables, as shown in the example with `minAmountRequested` in the SELECT section of the README.

Question 2

sqlf vs squirrel: which SQL builder is better for Go projects?

Accepted Answer

sqlf focuses on performance and memory efficiency with reuse, making it ideal for high-load applications. Squirrel offers more features like named placeholders and a larger ecosystem. Choose sqlf for raw SQL control with optimization, or squirrel for broader functionality out-of-the-box.

Question 3

Can sqlf handle bulk insert operations efficiently?

Accepted Answer

Yes, sqlf supports bulk inserts using the `.NewRow()` method to add multiple rows in a single query, as demonstrated in the INSERT section of the README with examples of inserting two user records.

Question 4

How do I bind query results to private struct fields in sqlf?

Accepted Answer

Use the `.To()` method to bind individual columns to private fields, as shown in the README example where `id`, `product_id`, etc., are mapped to private fields of an Offer struct, providing granular control over data retrieval.

Question 5

Does sqlf support transaction management with database/sql?

Accepted Answer

sqlf is compatible with `database/sql`, so you can use standard Go transaction methods externally. However, it doesn't provide built-in transaction helpers; you'll need to manage transactions manually using the database driver.

Question 6

What are the main limitations of sqlf compared to a full ORM like GORM?

Accepted Answer

sqlf lacks ORM features such as schema migrations, automatic relationship handling, and compile-time safety. It's designed for developers who prefer writing raw SQL but need dynamic query building, whereas GORM offers higher-level abstractions and more tooling.

sqlf

What is sqlf?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions