# How BQ legacy SQl is different form the standard SQL?

BQ provides two types of SQL to their user: Standard SQL and Legacy SQL. Why it is so and how both of them are different from each other.

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Content Writer at GadgetsDesk
- Net upvotes: 1


## Comments
### Comment 1

Legacy SQL is a non-standard SQL only used by BigQuery. Standard SQL is compliant with the SQL 2011.
Google recommends using Standard SQL and looking at the documentation and looking at the documentation it looks more and more like Google are deprecating Legacy SQL.

There are multiple advantages using Standard SQL. Read more about it here: https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql#advantages_of_standard_sql

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: CTO & Co-founder at Dreamdata




## Related Product
[Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews)

## Related Category
[Data Warehouse](https://www.g2.com/categories/data-warehouse)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4