Default highlight-style does not highlight well SQL code block

Description

Hi,

I'm trying to display SQL code with highlighted syntax in a reveal JS presentation.

Here is my .qml code:

---
title: "test"
format: 
  revealjs:
    theme: beige
    smaller: false
    self-contained: true
    slide-number: c/t
    code-line-numbers: false
date: "septembre 2023"
date-format : "MMM YYYY"
---

```sql
select * from table1;
```

But my SQL keywords "select" and "from" are not highligthed (different color on keywords) in the HTML rendered doc (I'm using RStudio to compile the HTML document).
Did I miss something to achieve this?

Thanks in advance for your help.

Originally posted by @ced75 in https://github.com/quarto-dev/quarto-cli/discussions/6644

Use the embedded .qml example as the reproduction entry point and compile it in RStudio to inspect the generated revealjs HTML. Confirm whether SQL keywords such as select and from receive distinct highlighting; done when the default highlight style renders them differently.