`synth_column_integer_sequence()` is happy to do numeric sequences

[jabortell]

I found that synth_column_integer_sequence() is happy to do numeric sequences. For example, this works:

{{ synth_column_integer_sequence(name="quarter_steps", step=0.25, start=1) }}

Might make sense to rename this macro to synth_column_numeric_sequence(), or to implement it separately then enforce integer steps in synth_column_integer_sequence()?

[tomreitz]

@jabortell this is interesting, thanks for pointing it out. My guess is that the behavior may be different with different backends (Snowflake, Postgres, DuckDB, etc.) - which backend(s) have you tested with?

If it is true in all backends, then I agree that

• moving most of the code into a new synth_column_numeric_sequence() macro
• (for backwards compatibility) have synth_column_integer_sequence() verify that step is an integer and then call synth_column_numeric_sequence()

sounds like a good plan.

If it's true only in some backends, maybe we leave synth_column_integer_sequence() but document the "special" behavior for those backends that have it?