Bulk delete WordPress Post and all metadata, etc using SQL query

Is it still possible to bulk delete WordPress post and it’s meta data, etc using an SQL query, I tried using some queries from years ago but didn’t work.

How can I do this?