DuckDB has a list_zip() function that zips one or more lists to a new list with a length of the longest list provided. The new list contains unnamed structs of the elements from the original lists. We pass the lists to the function when we call it. We can also pass a Boolean value to specify whether or not to truncate all lists to the smallest list.

Below are some basic examples that demonstrate how the list_zip() function works.

DuckDB’s list_select() function allows us to extract specific elements from list columns based on their positions. This can be useful when we need to access or manipulate elements within arrays or lists.

While it’s true that DuckDB has a list_sort() function that allows us to sort lists, it’s also true that there’s a list_reverse_sort() function that sorts lists in reverse order.

DuckDB has a list_sort() function that does exactly what its name promises; sorts lists.

While the easiest way to use this function is to simply pass a list, we can also pass other arguments to fine-tune the results.