sql

Execute a SQL query against Dataverse (transpiled to FetchXML)

Usage

ppds query sql [options]

Arguments

Name	Required	Description
sql	yes	SQL query string. Can be omitted if using --file or --stdin.

Options

Long	Short	Type	Default	Description
--confirm		bool		Confirm DML execution without interactive prompt
--correlation-id		string		Correlation ID for distributed tracing
--count	-c	bool		Include total record count in results
--debug		bool		Show trace-level diagnostic output
--dry-run		bool		Show the execution plan without running the DML statement
--environment	-env	string		Override the environment URL. Takes precedence over profile's bound environment.
--explain		bool		Show the execution plan without executing the query
--file		FileInfo		Read SQL from a file
--no-limit		bool		Remove the 10,000 row safety cap for DML operations
--output-format	-f	OutputFormat		Output format
--page		int?		Page number (1-based) for paged results
--paging-cookie		string		Paging cookie from previous query for continuation
--profile	-p	string		Authentication profile name
--quiet	-q	bool		Show only warnings and errors
--show-fetchxml		bool		Output the transpiled FetchXML instead of executing the query
--stdin		bool		Read SQL from standard input
--tds		bool		Route query through the TDS Endpoint (direct SQL) instead of FetchXML
--top	-t	int?		Limit the number of results returned
--verbose	-v	bool		Show detailed output including debug messages