driver "sqlite" not supported

[xtcw255]

Relevant telegraf.conf

# # Read metrics from SQL queries
[[inputs.sql]]
#   ## Database Driver
#   ## See https://github.com/influxdata/telegraf/blob/master/docs/SQL_DRIVERS_INPUT.md for
#   ## a list of supported drivers.
driver = "sqlite"
#

Logs from Telegraf

2023-09-04T11:13:32Z E! [telegraf] Error running agent: could not initialize input inputs.sql: driver "sqlite" not supported use one of [clickhouse cockroach flightsql maria mssql mysql pgx pgx/v4 postgres snowflake sqlserver tidb]

System info

Telegraf 1.27.4, Winserver 2019

Docker

No response

Steps to reproduce

1. Read https://github.com/influxdata/telegraf/blob/master/docs/SQL_DRIVERS_INPUT.md
2. Set driver to sqlite
3. Observe the error
   ...

Expected behavior

Expect to not get an error about sqlite being unsupported

Actual behavior

Get an error about it being unsupported

Additional info

No response

[powersj]

Hmm in #11260 I thought we allowed windows. I did confirm that upstream does support windows as well. It appears #11664 constrained things further, in order to "sync build constraints found in the sql output for the sqlite"

I have put up #13865 which removes the restrictions for everything except the mips builds. Let's see what CI says and if there are artifacts produced I'll need you to confirm that this works again on Windows.

Thanks!