supportsWindowOffsetFunctions property

bool get supportsWindowOffsetFunctions

LAG, LEAD, FIRST_VALUE and LAST_VALUE: the window functions that read another row of the same partition, added in SQL Server 2012.

Separate from supportsWindowFrames although both arrived together, because the two are refused with different advice. A frame can usually be dropped — the default frame is what the caller meant anyway — while there is no rewrite for LAG short of joining the table to itself on a row number, which is a different query.

Implementation

bool get supportsWindowOffsetFunctions => _atLeast(11, 110);