Google is experimenting with a new AI feature in its BigQuery data warehouse that helps generate parts of SQL queries from natural-language comments. This aims to make data analysis faster and easier, especially for teams working with complex queries. The goal is to simplify data access and help enterprises move their AI projects into production more smoothly.

How the Comments to SQL Feature Works

The new feature, called Comments to SQL, allows users to write natural-language instructions inside SQL comments. These comments are marked by /* and */, and users can describe what they want, such as specific columns, datasets, or filters. Once written, users can convert these comments into actual SQL code with a click inside BigQuery Studio.

To get started, users need to enable a special widget called SQL Generation. After that, they write their instructions directly in comments within their SQL scripts. When ready, they select an option to convert the comments into SQL code. This process shows a side-by-side diff view, illustrating how the natural language was translated into executable SQL. Users can then refine their instructions to get the desired results.

Examples and Limitations

Google provided examples to show how this works. For instance, a user might write a comment asking for a query that shows product names, monthly sales, and product rankings within categories for the year 2023. The tool then generates the corresponding SQL statement, including window functions and filters, based on that comment.

However, the system isn’t perfect yet. It’s still a work in progress and can’t turn simple comments like “give me a list of products by category ranked by sales in 2023” directly into accurate queries. The process requires some manual adjustments and further refinement to ensure the generated SQL does exactly what the user wants.

Why This Matters for Data Teams

Experts say this feature could speed up daily data tasks significantly. People working with data often think in terms of questions and results, not SQL syntax. Translating those questions into efficient SQL takes time, especially with complex joins and date calculations.

By allowing natural language comments inside SQL scripts, Google aims to cut down on that time. This means teams can spend less effort writing and rewriting queries, and more time analyzing results. It could lead to more automated workflows, faster insights, and less handoff between team members.

Google has been adding AI features to BigQuery for a while now, and this new tool continues that trend. The company hopes that making SQL more accessible will help more organizations leverage their data and accelerate their AI initiatives.

Inspired by

• https://www.infoworld.com/article/4118161/google-tests-bigquery-feature-to-generate-sql-queries-from-english.html

Sources

• google.com