Using SQL functions for default values doesn't work with dataclass record insertion API

[ozpau]

See this notebook for the demonstration of the issue: https://github.com/ozpau/fastlite_dataclass_default_functional/blob/main/nbs/00_core.ipynb

Or this quarto rendered page if you prefer: https://ozpau.github.io/fastlite_dataclass_default_functional/core.html

[ozpau]

Part of the reason is the last line in apswutils.db._decode_default_value:

def _decode_default_value(value):
    if value.startswith("'") and value.endswith("'"):
        # It's a string
        return value[1:-1]
    if value.isdigit():
        # It's an integer
        return int(value)
    if value.startswith("X'") and value.endswith("'"):
        # It's a binary string, stored as hex
        to_decode = value[2:-1]
        return binascii.unhexlify(to_decode)
    # If it is a string containing a floating point number:
    try:
        return float(value)
    except ValueError:
        pass
    return value

The different between strings and SQL functions is that strings are quoted, but after this function executes we no longer pass forward any information on whether the original value was a string or a function.