stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.57k stars 1.54k forks source link

Implements built-in window functions #1228

Closed geoffmacd closed 4 months ago

geoffmacd commented 7 months ago

Adds window functions to Sqlite.swift, see https://www.sqlite.org/windowfunctions.html#built_in_window_functions. The OVER cause was problematic in the current structure of the code, so for now, only OVER (ORDER BY {expression}) is supported but that is most of the use cases. The ORDER BY used here is not the same as the func order() in QueryType and cannot used like this.