geofileops.execute_sql

geofileops.execute_sql(path: Union[str, PathLike[Any]], sql_stmt: str, sql_dialect: Optional[str] = None)

Execute a SQL statement (DML or DDL) on the file.

To run SELECT SQL statements on a file, use read_file().

Parameters:

• path (PathLike) – The path to the file.

• sql_stmt (str) – The SQL statement to execute.

• sql_dialect (str) – The SQL dialect to use: * None: use the native SQL dialect of the geofile. * ‘OGRSQL’: force the use of the OGR SQL dialect. * ‘SQLITE’: force the use of the SQLITE dialect. Defaults to None.