The invention belongs to the technical field of
data query, and particularly discloses an
SQL2API (structured
query language 2 application program interface) method in a data table and HTTP (
hyper text transport protocol) interface
mixed mode based on a
large model, which comprises the following steps of: automatically mapping
metadata of an HTTP interface into a
virtual database table, and constructing to obtain a unified
SQL Schema view; utilizing the
SQL Schema view to convert a user query demand into a logic operation sequence, and generating a
query plan capable of realizing cross-source association; and according to the
query plan, executing the query of the SQL
database and the calling of the HTTP interface in parallel, integrating the obtained query result and the calling result into a two-dimensional table structure in the temporary memory
database, and returning the two-dimensional table structure to the user. According to the method, the HTTP interface
metadata is automatically mapped into the
virtual database table, and the
query plan is generated by using the
large model, so that efficient, unified and intelligent query of the
database and HTTP interface mixed
data source is realized.