Delete WordPress posts from URL list sql query

Yes you can.
To delete posts with inherit post meta, use following code:

DELETE
p,pm
FROM wp_posts p
JOIN wp_postmeta pm ON pm.post_id = p.id
WHERE p.post_name IN ('post-1', 'post-2', 'post-3')

Pass slugs array to WHERE clause.

If you want to delete only posts w/out postmeta (for some reason), use this code:

DELETE
FROM wp_posts
WHERE post_name IN ('post-1', 'post-2', 'post-3')