Useful list functions

[jexp]

There might be a few useful ones that we’re missing

https://duckdb.org/docs/sql/functions/nested

same for math and geo functions

Created a google sheet report.

---

Here is the missing nested functions:

• list_dot_product(list1, list2)
• list_grade_up(list)
• list_resize(list, size[, value])
• list_where(value_list, mask_list)
• list_zip(list1, list2, ...)
• range

Here is the missing numeric functions:

• bit_count(x)
• cbrt(x)
• even(x)
• factorial(x)
• greatest_common_divisor(x, y)
• lcm(x, y)
• least_common_multiple(x, y)
• lgamma(x)
• log2(x)
• nextafter(x, y)
• sign(x)
• signbit(x)

Here is the missing geo functions:

• VARCHAR ST_AsText(GEOMETRY)
• WKB_BLOB ST_AsWKB(GEOMETRY)
• VARCHAR ST_AsHEXWKB(GEOMETRY)
• VARCHAR ST_AsGeoJSON(GEOMETRY)
• GEOMETRY ST_GeomFromText(VARCHAR)
• GEOMETRY ST_GeomFromWKB(BLOB)
• GEOMETRY ST_GeomFromHEXWKB(VARCHAR)
• GEOMETRY ST_GeomFromGeoJSON(VARCHAR)
• GEOMETRY ST_Envelope_Agg(GEOMETRY)
• GEOMETRY ST_Union_Agg(GEOMETRY)
• GEOMETRY ST_Intersection_Agg(GEOMETRY)
• BOOLEAN ST_Within(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Touches(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Overlaps(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Contains(GEOMETRY, GEOMETRY)
• BOOLEAN ST_CoveredBy(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Covers(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Crosses(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Difference(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Disjoint(GEOMETRY, GEOMETRY)
• BOOLEAN ST_Intersects(GEOMETRY, GEOMETRY)
• BOOLEAN ST_DWithin(GEOMETRY, GEOMETRY, DOUBLE)