Limit on foreign table to filter select query?

const { data, error } = await client
  .from("user_content_queue")
  .select(
    "title, content, type, target_url, format, priority, id, published_at, digest_id (id, created_at)"
  )
  .order("created_at", { foreignTable: "digest_id", ascending: false })
  .limit(1, { foreignTable: "digest_id" })
  .order("type", { ascending: false })
  .order("priority", { ascending: true });