API functionality for DDL statements

[gadeynebram]

Hi,

I found this issue #19519 regarding the API.

Previously I was working with Azure Data Studio which is end of support. Specifically I was working with the data virtualisation wizard offered there. Since this will not be provided through the mssql extension, I was looking into creating a new extension for VSCode. One that provides a reduced set of the functionality that I used. I was trying to use the exported API for this.

I found the executeSimpleQuery method but this does not seem to allow for DDL statements to be executed. Are there any additional methods available for this?

vscode-mssql/typings/vscode-mssql.d.ts

Lines 2547 to 2556 in accc24d

	/**
	* Execute a simple query on the database using the connection URI.
	* @param connectionUri The URI of the connection to use for executing the query.
	* @param queryString The SQL query to execute.
	* @returns A promise that resolves with the result of the query execution.
	*/
	executeSimpleQuery(
	connectionUri: string,
	queryString: string,
	): Promise<SimpleExecuteResult>;