gsqlcmd Version History

gsqlcmd Version History

Version 6.0, July 5, 2022

A new major release has three new big features:

  • gsqlcmd natively supports the Basic, Windows, Forms, OAuth1, OAuth2 authorization methods, contains a complete set of the required options, and allows acquiring the authorization interactively.
  • SELECT queries from files and URLs support WHERE and ORDER BY clauses.
  • An auto-update tool allows checking and installing software updates.

Changes in End-User License Agreement:

gsqlcmd includes an updated End-User License Agreement.

The most important change:

"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."

New features:

  • gsqlcmd includes the AutoUpdate tool to check and install gsqlcmd updates.
    gsqlcmd checks updates according to a customized scheduler.
    You can run the update tool manually using the AutoUpdate mode.
  • gsqlcmd supports WHERE and ORDER BY clauses in SELECT queries from files and URLs.
  • gsqlcmd uses the convert mode by default for inline SELECT queries from files and URLs.
  • gsqlcmd supports the following authorization schemas with the Auth option: Auto, None, Basic, Windows, Forms, OAuth1, OAuth2, Custom.
    Use a new /interactive option to acquire authorization credentials in the interactive mode.
  • gsqlcmd has new OAuth2-specific modes and options.
    Modes: get-authcode, get-token, refresh-token, and revoke-token.
    Options: /authorizationUrlFormat, /getTokenUrlFormat, /getTokenBodyFormat, /refreshTokenUrlFormat, /refreshTokenBodyFormat, /revokeTokenUrlFormat, /revokeTokenBodyFormat, /authorizationUrl, /getTokenUrl, /refreshTokenUrl, /revokeTokenUrl, /code, /validTo.
  • gsqlcmd has new OAuth1-specific modes and options.
    Modes: get-authcode, get-token, and refresh-token.
    Options: /consumerKey, /consumerSecret, /callback, /requestTokenUrl, /authorizationUrl, /accessTokenUrl, /oauthToken, /oauthTokenSecret, /oauthSessionHandle, /oauthExpiresIn, /validTo.
  • gsqlcmd supports user-defined options used in OAuth1 and OAuth2 authorization.
    For example, you can set values of the accounts-server option acquired from ZohoCRM to use the values in the /get_token_url_format and /refresh_token_url_format options.
  • gsqlcmd has new /cookie and /cookieFile options especially useful with the Forms authorization.
  • gsqlcmd has new /urlParameters and /authorizationHeader options used with the custom authorization.
    gsqlcmd adds URL parameters to a URL and sets the authorization header of the web requests.
    You can achieve the same result specifying an initial URL with the parameters and the header like /header=Authorization: <AuthorizationHeader>.
  • gsqlcmd has a new /tokenFields option that explicitly allows specifying fields to save in the /tokenJson file.
  • gsqlcmd has a new /serviceJson option designed to load service configurations from JSON or plain text files.
    You can split client, service, and token options across the files like /clientJson=client.json /serviceJson=service.json /tokenJson=token.json
  • gsqlcmd has a new /acceptEncoding option with the default value: gzip, deflate.
  • gsqlcmd reads the default values of the Accept and UserAgent headers from the gsqlcmd.exe.config file.
  • Plain text option files can contain line comments starting with the # character.
  • gsqlcmd shows the shortest help by default. Use /? to get more help and the help mode to get the full help.

Bug fixes:

  • gsqlcmd outputs the last put options only from Yahoo Finance.