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: 
Depending on what kind of filtering is acceptable to you, you may be able to work around this by switching to OMIT IF from WHERE. It will give different results, but, again, perhaps such different results are acceptable. 
The following will remove entire hit record if (some) page inside of it meets criteria. Note two things here:

* it uses OMIT hits IF, instead of more commonly used OMIT RECORD IF).
* The condition is inverted, because OMIT IF is opposite of WHERE

The query is:

```
SELECT *
FROM [dataset.table]
OMIT hits IF EVERY(NOT hits.page.pagePath CONTAINS "my-fun-path")

```
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" 

```