It’s not in standard SQL, but is present in most SQL implementations:

https://www.postgresql.org/docs/current/sql-explain.html

https://www.sqlite.org/lang_explain.html

https://mariadb.com/kb/en/explain/