I'm actually using the '/2.0/preview/sql' endpoint.

I tried to use this one in the past but seems that the return has a limitation. Should I switch to the jobs API?