Add `VIEW` documentation

[hatyo]

With the introduction of support for SQL views in #3670, we should expand our documentation to cover views, including how to define them, their capabilities, limitations, and other relevant information.