SQlite errors when setting BOOLEAN

[sjunepark]

Version

1.25.0

What happened?

Hi,

If I type a field as BOOLEAN, sqlc creates a struct with type bool.

CREATE TABLE IF NOT EXISTS locations
(
    ValidPosition      BOOLEAN NOT NULL CHECK (ValidPosition = 0 OR ValidPosition = 1),
)

type Location struct {
	Validposition      bool
}

Which results to a INSERT error below

unsupported type bool

As a current work around, I'm just defining related field as INTEGERs, which probably won't be different internally.

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

version: "2"
sql:
  - engine: "sqlite"
    queries: "./db/sqlc/query.sql"
    schema: "./db/sqlc/schema.sql"
    gen:
      go:
        package: "sqlc"
        out: "internal/sqlc"

Playground URL

No response

What operating system are you using?

macOS

What database engines are you using?

SQLite

What type of code are you generating?

Go

[sjunepark]

My mistake,

Found out that this wasn't about sqlc and it was because I used the libsql driver when opening the db.
Changing sql.Open("libsql", "file:"+dbName) to sql.Open("sqlite3", "file:"+dbName) and removing `libsql related code solved it.