How to Use

Import the psql package and the query mod packages for the different query types

import (
    "github.com/stephenafamo/bob/dialect/psql"
    "github.com/stephenafamo/bob/dialect/psql/sm"
    "github.com/stephenafamo/bob/dialect/psql/im"
    "github.com/stephenafamo/bob/dialect/psql/um"
    "github.com/stephenafamo/bob/dialect/psql/dm"
)

func main() {
    psql.Select(
        sm.From("users"),
    )

    psql.Insert(
        im.Into("users"),
    )

    psql.Update(
        um.Table("users"),
    )

    psql.Delete(
        dm.From("users"),
    )

    psql.Raw()
}

Dialect Support

Query types

View the reference for the query mod packages:

• Raw
• Select: Query Mods
• Insert: Query Mods
• Update: Query Mods
• Delete: Query Mods

Starters

These are Postgres specific starters, in addition to the common starters

• CONCAT(...any): Joins multiple expressions with "||"

  // SQL: a || b || c
  psql.Concat("a", "b", "c")

Operators

These are Postgres specific operators, in addition to the common operators

• BetweenSymmetric(y, z any): X BETWEEN SYMMETRIC Y AND Z
• NotBetweenSymmetric(y, z any): X NOT BETWEEN SYMMETRIC Y AND Z