What is the parallel hint in SQL query?

Could you please explain what is meant by the term "parallel hint" in the context of an SQL query? Is it a feature that can be used to optimize the performance of a query by enabling it to execute in parallel across multiple processors or cores? How does it work, and what are the benefits and drawbacks of using a parallel hint in an SQL query? Additionally, are there any specific SQL databases or versions that support this feature, or is it a more universal concept in SQL query optimization?