[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_194":195,"_196":197},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_146":-5,"_20":147,"_22":148,"_149":150,"_151":152,"_25":153,"_24":-5,"_154":-5,"_155":-5,"_156":55,"_157":158,"_159":55,"_160":-5,"_161":-5,"_162":163},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","kaleidawave","name","sqlite-client","branchName","main","version","path","","project",{"_35":87,"_13":14,"_47":88,"_89":-5,"_90":55,"_91":92,"_93":92,"_94":95,"_96":-5,"_97":98,"_99":-5,"_100":55,"_101":-5,"_102":-5,"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":124,"_125":126,"_127":128,"_129":55},"tree",[74,75,76],"file","contents",[32,33,34],"upstream","pull","ahead","behind","envVars",{"_35":66,"_13":67,"_38":68,"_40":-5,"_41":42,"_43":69,"_45":46,"_47":70,"_17":71,"_50":24,"_52":72,"_54":55,"_56":-5,"_18":73},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":51,"_52":64,"_54":55,"_56":-5,"_18":65},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","f9d09430-020d-11f1-b687-42dde27851f2","main.ts","fileId","3e5b43e6-01b1-11f1-9970-42dde27851f2","parentId","branchId","3e5926d8-01b1-11f1-9970-42dde27851f2","branchVersion",21,"latest",true,"createdAt",["D",1770239447366],5,"fileType","script","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n\t/**\n\t * The SQL statement to execute.\n\t */\n\tsql: string;\n\n\t/**\n\t * The arguments to bind to the SQL statement.\n\t */\n\targs: InArgs;\n} | string;\n\nexport interface ResultSet {\n\t/** Names of columns.\n\t *\n\t * Names of columns can be defined using the `AS` keyword in SQL:\n\t *\n\t * ```sql\n\t * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n\t * ```\n\t */\n\tcolumns: Array;\n\n\t/** Types of columns.\n\t *\n\t * The types are currently shown for types declared in a SQL table. For\n\t * column types of function calls, for example, an empty string is\n\t * returned.\n\t */\n\tcolumnTypes: Array;\n\n\t/** Rows produced by the statement. */\n\t// TODO real value rows: Array>;\n\trows: Array;\n\n\t/** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n\t *\n\t * This value is not specified for other SQL statements.\n\t */\n\trowsAffected: number;\n\n\t/** ROWID of the last inserted row.\n\t *\n\t * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n\t * table.\n\t */\n\tlastInsertRowid: bigint | undefined;\n}\n\nexport type TransactionMode = \"write\" | \"read\" | \"deferred\";\n\nexport interface SQLClient {\n\texecute(statement: InStatement): Promise;\n\tbatch(\n\t\tstatements: InStatement[],\n\t\tmode?: TransactionMode,\n\t): Promise\n}\n\nconst valTownSQLClient: SQLClient = {\n\tasync execute(statement) {\n\t\tconst out = await sqlite.execute(statement);\n\t\treturn { ...out, rows: out.rows.map((row: Array) => buildObject(row, out.columns)) }\n\t},\n\tasync batch(_statements, _mode) {\n\t\tthrow new Error(\"TODO batch\");\n\t},\n}\n\n/** For SQL client */\nexport function buildObject(row: Array, headers: Array, _kindHeaders: Array = []) {\n\tconst object = {};\n\tfor (let i = 0; i < headers.length; i++) {\n\t\tReflect.set(object, headers[i], row[i]);\n\t}\n\treturn object;\n}\n\nexport default valTownSQLClient;","deleted",false,"label",[37],"19993150-01b4-11f1-9e48-42dde27851f2","example.ts","34f22be8-01b2-11f1-94fa-42dde27851f2",18,["D",1770200846031],9,"import { sqlite as sqlite1 } from \"https://esm.town/v/std/sqlite\";\nimport sqlite2 from \"https://esm.town/v/kaleidawave/sqlite-client/global.ts\"; // TODO how can we drop the `/global.ts`\n\nconsole.dir({\n 1: await sqlite1.execute(\"SELECT 1 as x;\"),\n 2: await sqlite2.execute(\"SELECT 1 as x;\"),\n})",[59],"b8dd48b4-0209-11f1-8d35-42dde27851f2","README.md","8d7aa49c-01b3-11f1-921b-42dde27851f2",19,["D",1770237620457],4,"A wrapper for 'https://esm.town/v/std/sqlite' that turns the value array into objects.\n\n### TODO\n\n- A 1:1 API match with the Bun SQLite API **but** with `Promise` results instead (due to technical differences)?",[67],{"_35":66,"_13":67,"_38":68,"_40":-5,"_41":42,"_43":69,"_45":46,"_47":84,"_17":71,"_50":24,"_52":72,"_54":55,"_56":-5,"_78":85,"_18":86},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":81,"_17":63,"_50":51,"_52":64,"_54":55,"_56":-5,"_78":82,"_18":83},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":77,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_78":79,"_18":80},["D",1770239447366],"children",[],[37],["D",1770200846031],[],[59],["D",1770237620457],[],[67],"3e58dd4a-01b1-11f1-9970-42dde27851f2",["D",1770199619201],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","a wrapper for 'https://esm.town/v/std/sqlite'","imageUrl","userId","af37484e-d053-4149-8be7-34ae3fff0459","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","76e92795-d42b-48fa-8fa3-5e72922deaf2","tursoName","3e58dd4a01b111f1997042dde27851f2","tursoHostname","3e58dd4a01b111f1997042dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789555289887],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_145":141},"org",{"_11":12,"_138":139,"_140":141,"_97":98,"_142":143,"_144":55},"branch",{"_17":44,"_13":16,"_35":42,"_130":87,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Ben","avatar","https://images.clerk.dev/oauth_github/img_2OMdMDIVzVrD6DdvO4fcLjF8gch.jpeg","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":87,"_13":14,"_47":189,"_89":-5,"_90":55,"_91":92,"_93":92,"_94":95,"_96":-5,"_97":98,"_99":-5,"_100":55,"_101":-5,"_102":-5,"_103":104,"_105":106,"_107":108,"_109":110,"_111":190,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":191,"_125":192,"_127":193,"_129":55},[180,181,182],"files",[180,181,182],"counts",{"_170":104,"_171":172,"_173":104,"_31":174,"_175":176},[164,165,166],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":66,"_13":67,"_38":68,"_40":-5,"_41":42,"_43":69,"_45":46,"_47":70,"_17":71,"_50":24,"_52":72,"_54":55,"_56":-5,"_18":169},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":51,"_52":64,"_54":55,"_56":-5,"_18":168},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":167},[37],[59],[67],"pulls","branches",1,"forks",{"_177":104,"_179":104},"connections",{"_177":104,"_178":104},"count","unfilledCount","emptyCount",{"_35":66,"_13":67,"_38":68,"_40":-5,"_41":42,"_43":69,"_45":46,"_47":84,"_17":71,"_50":24,"_52":72,"_54":55,"_56":-5,"_78":187,"_18":188},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":81,"_17":63,"_50":51,"_52":64,"_54":55,"_56":-5,"_78":185,"_18":186},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":77,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_78":183,"_18":184},[],[37],[],[59],[],[67],["D",1770199619201],["D",1789555289887],{"_11":12,"_145":141},{"_11":12,"_138":139,"_140":141,"_97":98,"_142":143,"_144":55},{"_17":44,"_13":16,"_35":42,"_130":87,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_123":-5,"_161":227,"_228":229,"_230":231,"_232":55,"_233":55,"_234":55,"_235":46,"_236":-5,"_237":-7,"_238":-7,"_239":104,"_240":55,"_241":55,"_242":-5,"_243":55,"_244":55,"_245":55,"_246":-5},"ENV",{"_198":199,"_200":201,"_202":16,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code