Bug: Create view doesn't work with a select statement in parentheses

[talagluck]

Description

This works

CREATE TABLE table_no_paren AS SELECT 1;

and this works

CREATE VIEW view_no_paren AS SELECT 1;

and this works

CREATE TABLE table_yes_paren AS (SELECT 1);

but this doesn't work

CREATE VIEW view_yes_paren AS (SELECT 1);

It raises

Query failed to run.

Invalid view statement: view body must either be a SELECT or VALUES statement

This is an issue because of the way that dbt works - by default it takes the dbt code that you write and renders queries with the select statement in parentheses, and by default, it uses views rather than tables for efficiency purposes.