Converting a more complex query to Kysely

SELECT
  *,
  (
    SELECT
      COUNT(*)
    FROM
      zamdle_clips AS c2
    WHERE
      c2.id < c1.id
      AND c2.shahz_response IS NULL
  ) + 1 AS position_in_queue
FROM
  zamdle_clips AS c1
WHERE
  twitch_id = 'some_input_id'
ORDER BY
  id;

SELECT
  *,
  (
    SELECT
      COUNT(*)
    FROM
      zamdle_clips AS c2
    WHERE
      c2.id < c1.id
      AND c2.shahz_response IS NULL
  ) + 1 AS position_in_queue
FROM
  zamdle_clips AS c1
WHERE
  twitch_id = 'some_input_id'
ORDER BY
  id;

  const result = await db
    .selectFrom("zamdle_clips")
    .selectAll()
    .where("twitch_id", "=", twitch_id)
    .orderBy("id")
    .select(({ selectFrom }) => [
      selectFrom("zamdle_clips").selectAll().as("c1"),
      selectFrom("zamdle_clips")
        .select(({ fn }) => fn.countAll().as("count"))
        .where("shahz_response", "is", null)
        .as("position_in_queue"),
    ])
    .execute();

  const result = await db
    .selectFrom("zamdle_clips")
    .selectAll()
    .where("twitch_id", "=", twitch_id)
    .orderBy("id")
    .select(({ selectFrom }) => [
      selectFrom("zamdle_clips").selectAll().as("c1"),
      selectFrom("zamdle_clips")
        .select(({ fn }) => fn.countAll().as("count"))
        .where("shahz_response", "is", null)
        .as("position_in_queue"),
    ])
    .execute();