Query with Select on Calculated Column

I tried unsuccesfully to run this query

Straight line of Graph Absolute M_r versus u-r rest frame
y = mx + c where m = -0.083 and c = 0.58

```
import numpy as np
import scipy.stats as st
from astroquery.gama import GAMA
import matplotlib.pyplot as plt
Straight line of Graph Absolute M_r versus u-r rest frame
y = mx + c where m = -0.083 and c = 0.58
x_col = ' absmag_r, '
y_col = ' uminusr, '
y_del = ' (0.58 - absmag_r * 0.083) - uminusr as y_del '
query = 'SELECT '+x_col+y_col+y_del+' FROM StellarMasses \
WHERE y_del < 0.3 LIMIT 10'
print(query)
result = GAMA.query_sql(query)
print(result)
```

But it gives me an error.

I assume it does not like the calculated column y_del.

I note if I leave off the WHERE it produces the table ok.

I am struggling to think of a way forward if both selection on calculated columns and creation of tables from queries is not supported.

What do other people do?

The issue names GAMA.query_sql and the StellarMasses query; start by reproducing the query with and without the WHERE clause and capture the exact error. Done means the supported behavior for filtering on the calculated y_del column is established, with the result documented or a clear workaround identified.

Written by the indexing model from the issue text.