建议: TypeScript 查询构建器

const penguins = prql.table('penguins', {
    "species": "string",
    "year": "int32",
    "bill_length_mm": "float64",
})

const by_year_species = penguins
    .group(
        r => [r.col("species"), r.col("year")],
        g => g
            .filter(r => r.col("bill_length_mm").is_not_null())
            .agg(
                g => ({
                    count: prql.count(),
                    mean_length: g.col("bill_length_mm").mean(),
                })
            )
    )
    .sort(r => r.col("mean_length"))
    .take(10)


const recent_longest_per_year = penguins
    .group(
        r => r.col("year"),
        g => g.sort(r => r.col("bill_length_mm").desc()).take(1)
    )
    .filter(r => r.col("bill_length_mm").gt(50))
    .derive(r => {
       bill_length_cm = r.col("bill_length_mm").div(10), // 由于 TypeScript 没有运算符重载，所以需要使用 .div() 来实现
       version = prql.sql<"string">("version()"),
     })