Database Reference
In-Depth Information
with procedural languages, SQL can initially seem awkward. However, given
some time, you may find yourself warming to the notion that the language
is well suited to the task of transforming structured data. The examples
covered are merely a starting point for all the interesting queries you can run
to extract meaningful information from your data.
One other important point is that BigQuery is constantly evolving the
capabilities of its SQL implementation. Over time, various awkward
restrictions have been dropped, and additional functions and language
features have been added. You will find that more of your analysis can be
done easily within the service.
Inevitably you will hit a problem that seems intractable in SQL. Consider
reaching out to the BigQuery StackOverflow forum mentioned in the
introduction or the broader SQL community for ideas on how to tackle
the problem. Even if we cannot solve your challenge, we are interested to
learn about the different kinds of problems people are trying to tackle. Who
knows, your question may lead to the next round of new language features
or functions.
