str_flatten has no default value for collapse arg

[fh-afrachioni]

On postgres, snowflake, redshift, and myql, str_flatten has no default value for the collapse arg, and throws an error without it. This is inconsistent with stringr::str_flatten, where collapse = '' is default.

Fixed in #992