I am running the below query

```
SELECT * 
FROM USER_MODEL 
WHERE "name"  = "Administrator"

```

However, I am getting an error message, not sure why the value is also considered a column name.

> 
> Column "Administrator" not found; SQL statement:
> 
> 
> 

When I tried to use single quotes.

```
SELECT * 
FROM USER_MODEL 
WHERE "name"  = 'Administrator' 

```

Then H2 again complains

> 
> Literals of this kind are not allowed; SQL statement:
> 
> 
> 

When the name is not enclosed double-quotes. The H2 converts the column name into the upper case.

```
SELECT * 
FROM USER_MODEL 
WHERE name  = "Administrator"

```

> 
> Column "NAME" not found; SQL statement:
> 
> 
> 

Need help on how H2 query works.