code: def test_deserailize_colprop(self):
      TestTable = self.classes.TestTable
  
      s = scoped_session(sessionmaker())
  
      expr = s.query(TestTable).filter(
          TestTable.some_primary_id == 123456
      )
  
      expr2 = serializer.loads(
          serializer.dumps(expr), TestTable.metadata, s
      )
  
      # note in the original, the same bound parameter is used twice
      self.assert_compile(
          expr,
          "SELECT "
          "CAST(left(test.some_id, :left_1) AS INTEGER) AS anon_1, "
          "test.id AS test_id, test.some_id AS test_some_id FROM test WHERE "
          "CAST(left(test.some_id, :left_1) AS INTEGER) = :param_1",
          checkparams={"left_1": 6, "param_1": 123456},
      )
  
      # in the deserialized, it's two separate parameter objects which
      # need to have different anonymous names.  they still have
      # the same value however
      self.assert_compile(
          expr2,
          "SELECT CAST(left(test.some_id, :left_1) AS INTEGER) AS anon_1, "
          "test.id AS test_id, test.some_id AS test_some_id FROM test WHERE "
          "CAST(left(test.some_id, :left_2) AS INTEGER) = :param_1",
          checkparams={"left_1": 6, "left_2": 6, "param_1": 123456},
      )
  
imports: from sqlalchemy import desc
  from sqlalchemy import ForeignKey
  from sqlalchemy import func
  from sqlalchemy import Integer
  from sqlalchemy import join
  from sqlalchemy import literal_column
  from sqlalchemy import MetaData
  from sqlalchemy import select
  from sqlalchemy import String
  from sqlalchemy import testing
  from sqlalchemy.ext import serializer
  from sqlalchemy.orm import aliased
  from sqlalchemy.orm import class_mapper
  from sqlalchemy.orm import column_property
  from sqlalchemy.orm import configure_mappers
  from sqlalchemy.orm import joinedload
  from sqlalchemy.orm import relationship
  from sqlalchemy.orm import scoped_session
  from sqlalchemy.orm import sessionmaker
  from sqlalchemy.testing import AssertsCompiledSQL
  from sqlalchemy.testing import eq_
  from sqlalchemy.testing import fixtures
  from sqlalchemy.testing.entities import ComparableEntity
  from sqlalchemy.testing.schema import Column
  from sqlalchemy.testing.schema import Table
label_desc: Use image node_id 2 for calling the ColumnPropertyWParamTest obj's underlying member method code with example usage: obj.test_deserailize_colprop() without return types