a lot of these are part of the dialect, and not actually sql "functions". (concat, intersect).
We don't yet have any documentation outlining our sql dialect, so those are omitted for now. However, "read_csv" should definitely have some documentation around it.