QUERYX allows you to use sql queries in sheets.
Those familiar with Google Sheets will probably want to know how this is different to the built-in
QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.
Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.