Is your feature request related to a problem or challenge?

@goldmedal added support for Async user defined functions in

• Introduce Async User Defined Functions  #14837

As @comphead points out, I don't know of any other database engine that supports this, so it would be a great idea to tell the world about it in a blog post

Describe the solution you'd like

The following would make a killer blog post:

1. Overview of async user defined functions and their usecases (calling LLMs, fetching http results, etc)
2. Example of creating an async UDF with datafusion (perhaps calling out to run http requests to fetch wikipedia pages and write results to a parquet file)
3. Description of how it is implemneted (example plan with AsyncFuncExec, etc)

Describe alternatives you've considered

No response

Additional context

No response