On Tue, Oct 20, 2015 at 5:35 PM, Jacques Nadeau <[email protected]> wrote:
> ** (4) Solve with specific syntax for the most common scenarios (very > declarative) ** > select * FROM > mydb.mytable > TREAT AS TEXT > USING > LINE DELIMITER '\n' > AND FIELD DELIMITER ',' > AND TREAT FIRST ROW AS HEADERS > > > I'm actually most inclined to the fourth. It seems like the most user > friendly. From a grammar perspective, I think you need to figure out a way > to use TREAT AS as a grammar switch so we can avoid protecting these > expressions in all contexts. What is nice about this pattern is that is > understandable by non-technical users and fits sql. Hiding things in a > table function makes things more complex. > This fourth is also least extensible and thus most disenfranchising for those outside the inner group. Table functions (hopefully) would be something that others could implement.
