pkg/58448: databases/sqlite3 is missing dbstat option

[campbell+netbsd%mumble.net@localhost]

>Number:         58448
>Category:       pkg
>Synopsis:       databases/sqlite3 is missing dbstat option
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Fri Jul 19 16:55:00 +0000 2024
>Originator:     Taylor R Campbell
>Release:        current, 2024Q2, ...
>Organization:
The NetBSqlDbstat Foundation
>Environment:
>Description:
The databases/sqlite3 package ships without the sqlite3 DBSTAT virtual table: https://sqlite.org/dbstat.html

It also has no build-time option to enable it.
>How-To-Repeat:
try to use, e.g., lang/tcl's sqlite3_analyzer (see also PR pkg/58447: https://gnats.NetBSD.org/58447)
>Fix:
Probably something like this:

--- a/databases/sqlite3/options.mk
+++ b/databases/sqlite3/options.mk
@@ -1,11 +1,15 @@
 # $NetBSD: options.mk,v 1.7 2023/02/20 07:28:31 wiz Exp $
 
 PKG_OPTIONS_VAR=		PKG_OPTIONS.sqlite3
-PKG_SUPPORTED_OPTIONS=		fts icu deserialize
+PKG_SUPPORTED_OPTIONS=		sqlite3-dbstat fts icu deserialize
 PKG_SUGGESTED_OPTIONS=		fts # enabled in NetBSD builtin version
 
 .include "../../mk/bsd.options.mk"
 
+.if !empty(PKG_OPTIONS:Msqlite3-dbstat)
+CFLAGS+=	-DSQLITE_ENABLE_DBSTAT_VTAB=1
+.endif
+
 .if !empty(PKG_OPTIONS:Mfts)
 CFLAGS+=	-DSQLITE_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1
 .endif