Intermittent TypeError in get_sql_value: isinstance() arg 2 must be a type, a tuple of types, or a union

[sarvesh-deserve]

Issue Description:

I've encountered an intermittent issue in the get_sql_value function where a TypeError occurs. The error message indicates that the problem is related to the isinstance() function, specifically at the line isinstance(value, datetime.datetime). The error message is as follows:

TypeError: isinstance() arg 2 must be a type, a tuple of types, or a union

Steps to Reproduce:
Unfortunately, I am unable to consistently reproduce this issue, which makes it challenging to pinpoint the exact cause. However, the error seems to occur intermittently during the execution of the get_sql_value function.

Expected Behavior:
The isinstance() function should accept datetime.datetime as a valid type for the value argument.

Actual Behavior:
Intermittently, the TypeError mentioned above occurs, preventing the code from executing as expected.

[dantownsend]

Interesting - I had a look at the code for get_sql_value and I can't see any obvious issues.

piccolo/piccolo/columns/base.py

Line 868 in d1f6c35

elif isinstance(value, datetime.datetime):

Which Python version are you running?

I Googled around, and found this discussion, but it's pretty old.

I wonder if there's anything in Piccolo or your application code which does something like:

datetime.datetime = 'foo'

i.e. overrides datetime.datetime, which then causes isinstance to fail.

[sarvesh-deserve]

I am using 3.11.2, and it is happening for integer column with default value as 0