Snowflake for good measure:  select seq8() as integer_sequence , dateadd(day, seq8() + 1, current_date) as calendar_date from table(generator(rowCount => 365))

For a few SQL dialects, including PostgreSQL and Snowflake, this can be handled with a fourth option—namely, aggregating the information into a semi-structured data type and using LookML to selectively choose the attributes of interest. Continuing wi...