US 11,934,361 B2
Automatic generation of a data model from a structured query language (SQL) statement
Colin Zima, San Francisco, CA (US); Jonathan Swenson, Santa Cruz, CA (US); Jamie Davidson, Portola Valley, CA (US); and Julian Hyde, Berkeley, CA (US)
Assigned to Google LLC, Mountain View, CA (US)
Filed by Google LLC, Mountain View, CA (US)
Filed on Jul. 7, 2022, as Appl. No. 17/811,270.
Application 17/811,270 is a continuation of application No. 17/071,893, filed on Oct. 15, 2020, granted, now 11,386,053, issued on Jul. 12, 2022.
Prior Publication US 2022/0335017 A1, Oct. 20, 2022
Int. Cl. G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/212 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2423 (2019.01); G06F 16/2456 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A computer-implemented method when executed by data processing hardware causes the data processing hardware to perform operations comprising:
receiving, from a user interface of a data analytics application, a single structured query language (SQL) query;
determining that the single SQL query satisfies a syntax error threshold; and
in response to determining that the single SQL query satisfies the syntax error threshold:
extracting, from the single SQL query, a first table reference;
identifying an alias for the first table reference, the alias referencing a second table reference;
obtaining, for the first table reference, fields associated with the first table reference;
obtaining, for the second table reference, fields associated with the second table reference; and
generating a data model using the alias, the fields obtained from the first table reference, and the fields obtained from the second table reference.