Question: I have little to no experience with databases and i'm wondering how i would go about storing certain parts of an object.

Let's say I have an object like the following and steps can be an arbitrary length. How would I store these steps or list of steps into an sql database?

```
class Error:
   name = "" #name of error
   steps = [] #steps to take to attempt to solve error

```

Answer: 
Update: see the [related](https://stackoverflow.com/questions/25583878/flattening-google-analytics-data-with-repeated-fields-not-working-anymore) thread, I am afraid this is no longer possible.
It would be possible to use NEST function and grouping by a field, but that's a long shot.

Using flatten call on the query:

```
SELECT *
FROM flatten([google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910],customDimensions)
WHERE
  hits.page.pagePath CONTAINS "m"  

```

Thus in the web ui:

* setting a destination table
* allowing large results
* and NO flatten results

does the job correctly and the produced table matches the original schema.
I know - it is old ask. 
But now it can be achieved by just using standard SQL dialect instead of Legacy

```
#standardSQL
SELECT t.*
FROM `dataset.table` t, UNNEST(hits.page) as page
WHERE
  page.pagePath CONTAINS "my-fun-path" 

```