Migrate documentation for remaining window functions to window_functions.md

[alamb]

Is your feature request related to a problem or challenge?

As part of https://github.com/apache/datafusion/issues/12740 this ticket is to migrate all the existing documentation for the above named functions from the static documentation to code and to remove them from the static file.

Here is the current static content:

• doc source: https://github.com/apache/datafusion/blob/main/docs/source/user-guide/sql/window_functions.md
• rendered: https://datafusion.apache.org/user-guide/sql/window_functions.html
• Code source: https://github.com/apache/datafusion/tree/main/datafusion/functions-window/src

Need Functions: (see source)

Describe the solution you'd like

One (or more) PRs that

1. port the documentation for the above named functions from the static docs to code
2. Bonus points: add sql examples should be added for all functions
3. Remove the documentation from the static docs
4. Run ./dev/update_function_docs.sh to update the dynamic documentation

Here are some example PRs of doing this:

1. https://github.com/apache/datafusion/pull/12840 from @jonathanc-n
2. https://github.com/apache/datafusion/pull/12775 from @Omega359
3. https://github.com/apache/datafusion/pull/12742

Describe alternatives you've considered

No response

Additional context

No response

[buraksenn]

take

[buraksenn]

I started working on this but I think this needs to be done after #8709 epic finishes since window functions are in progress of refactoring and they need to be refactored such that their documents are added in datafusion/functions-window/src instead of datafusion/expr/src/window_function.rs. I will track those changes and open a PR if it is okay

[alamb]

Thanks @buraksenn -- that sounds great. Thank you

[Omega359]

Would it be possible to add documentation for lead/lag prior to waiting for all the remaining window functions to be migrated over?

[buraksenn]

@Omega359 added lead/lag window function docs in the PR above

[alamb]

I think this is now done (thank you @buraksenn and @Omega359 )

I am hoping that we can merge https://github.com/apache/datafusion/pull/12938 and then that will prevent any new functions from being added that don't have documentation (aka it will ensure that the ported window functions are documented)