Priyank Patel

This plugin will help you to add a post/custom post list to any of the page using block editor.
You will also get all the filters like. number of posts to display, order by, list from specific taxonomy or terms, filter by date or range, show featured image, pagination, exclude posts, etc…
You can also modify the ttemplate just by coping the file: “templates/all-post-list-template.php” to your theme’s root directory.
<h3>Arbitrary section</h3>
You may provide arbitrary sections, in the same format as the ones above. This may be of use for extremely complicated 
plugins where more information needs to be conveyed that doesn’t fit into the categories of “description” or 
“installation.” Arbitrary sections will be shown below the built-in sections outlined above.

All Post Listing Block

Example block written with ESNext standard and JSX support – build step required.

Fabricio Carella

This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.
It also gives you the ability to export the results in a CSV format file.
In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the <code>install_plugins</code> capability, that means a Super Admin in the multi-site installation or an Admin in a single site.
Feel free to contribute: 
https://github.com/Sefirost/run-sql-query
Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

Run SQL Query

Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.

All Post Listing Block vs Run SQL Query