How to align query results in a column

[dideler]

When displaying results, is there a way align numerical results in a column or table?

For example, say we have the following query and results, the default is to left-align:

select number_format(paid, 2) as paid
from stdin

┌────────────┐
│    paid    │
├────────────┤
│ 85,000.00  │
│ 850.00     │
│ 85.00      │
│ 8.50       │
│    NULL    │
└────────────┘

I want the results to be right-aligned:

┌────────────┐
│    paid    │
├────────────┤
│ 85,000.00  │
│    850.00  │
│     85.00  │
│      8.50  │
│      NULL  │
└────────────┘

The string function lpad is close but you lose number formatting and numerical operations, not what I want.

select
  paid as paid_orig,
  number_format(paid, 2) as paid_num_fmt,
  lpad(paid, 9, ' ') as paid_str_fmt
from stdin

┌───────────┬──────────────┬──────────────┐
│ paid_orig │ paid_num_fmt │ paid_str_fmt │
├───────────┼──────────────┼──────────────┤
│ 85000.00  │ 85,000.00    │  85000.00    │
│ 850.00    │ 850.00       │    850.00    │
│ 85.00     │ 85.00        │     85.00    │
│ 8.50      │ 8.50         │      8.50    │
│   NULL    │     NULL     │     NULL     │
└───────────┴──────────────┴──────────────┘

I'm looking for an option to left/mid/right-align a column or table, no matter the data type or contents.

[dideler]

Formatting a number (plus any numerical operations) then padding it as a string works. Not as intuitive as an alignment option.

select
  paid as paid_orig,
  number_format(paid, 2) as paid_num_fmt,
  lpad(paid, 9, ' ') as paid_str_fmt,
  lpad(number_format(paid, 2), 9, ' ') as paid_fmt
from stdin

┌───────────┬──────────────┬──────────────┬────────────┐
│ paid_orig │ paid_num_fmt │ paid_str_fmt │  paid_fmt  │
├───────────┼──────────────┼──────────────┼────────────┤
│ 85000.00  │ 85,000.00    │  85000.00    │ 85,000.00  │
│ 850.00    │ 850.00       │    850.00    │    850.00  │
│ 85.00     │ 85.00        │     85.00    │     85.00  │
│ 8.50      │ 8.50         │      8.50    │      8.50  │
└───────────┴──────────────┴──────────────┴────────────┘