[C++] Add support for precision timestamp literals

[westonpace]

Describe the enhancement requested

Substrait added new precision timestamp types to replace the old (micros only) timestamp types. #40695 adds support for converting the types but we are unable to convert the literals due to substrait-io/substrait#611

Once that issue is resolved we can upgrade and add support for using the precision timestamp literals.

Component(s)

C++