LWC SOQL Builder is an online SOQL execution tool developed in LWC Open Source, the tool may be used straight away from your browser, saving time and making much more perceptible than using Developer Console.

I personally use this tool for a couple of months and it helps me when I quickly have to analyse a data consistency or export a CVS file to update via Dataloader.

Features

  • Point and Click User Interface: A point and click user interface enables you to add SOQL boilerplate, fields, parent relationships, subquery and run a query.
  • Autocomplete: Autocomplete is a feature that make you to complete field name. You can search by field label as well as by field name.
  • PWA Support: LWC SOQL Builder can be installed as Progressive Web App (PWA). You can install it like a normal desktop app.
  • Format SOQL: LWC SOQL Builder allows you to instantly beautify your SOQL queries. Formatted SOQL is very easy to use in Apex code.
  • CSV Export: You can export the query result to a CSV file. The CSV file can be upserted to Salesforce using Data Loader.
  • Support for ignoring default namespace: Support for ignoring default namespaceYou can run a SOQL without the namespace prefix of a managed package. So, you can copy and paste the SOQL into your Apex code as-is.
  • Setup in your local Machine: The project is open source and it is available on GitHub, so if you need you can even edit the source code.
Access LWC SOQL Builder

Source

https://github.com/lwc-soql-builder/lwc-soql-builder
https://lwc-soql-builder.github.io/lwc-soql-builder