Use NamedStmt when building queries

[marianysilva]

Short description

We can improve the readability and maintainability of our queries using NamedStmt

Description

One of the features sqlx offers is the NamedStmt, which represents a prepared statement. A NamedStmt allows you to use named parameters in your SQL queries instead of the positional parameters(?) that are typically used in prepared statements. Named parameters make your queries more readable and maintainable by allowing you to use meaningful names instead of remembering the order of parameters.

Example:

// FROM
SELECT * FROM courses WHERE uuid = $1
// TO
SELECT * FROM courses WHERE uuid = :uuid

@rluders applied NamedStmt in his Golang course here

Additional information

NamedStmt
microservice-with-go