doc-gen: Migrate builtin scalar functions from code based documentation to attribute based #13671
Description
Is your feature request related to a problem or challenge?
It is needed to migrate whenever it is possible builtin UDF documentation from code based to attribute based.
Function list can be found in SessionStateDefaults::default_scalar_functions()
Example can be found https://github.com/apache/datafusion/pull/13646/files#diff-1528bf73810e3fb12fd1d4e76a8b46acb650549ef37d3c131464e087f97ca515L25
The translation can be done manually or in semi automatic way, uncommenting a function in PR #13669 locally. This will generate local text files with attribute text which can be copy pasted to structs. However its still needed to remove code based documentation manually, add imports, etc
Please refer to PR #13646 which completed the migration for aggregation functions
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response