SELECT len(ISNUll(tableName.clumn,'')) AS CloumnLength FROM tableName;

SELECT len("isnull"(tablename.clumn, '')) AS cloumnlength FROM tablename;

    SELECT DISTINCT
           category0_.id AS id1_0_0_,
           segmentati1_.category_id AS category1_9_1_,
           segmentati1_.segmentation_id AS segmenta2_9_1_,
           segmentati2_.id AS id1_8_2_,
           inputtype3_.id AS id1_4_3_,
           operator5_.id AS id1_5_4_,
           configurat6_.key AS key1_1_5_,
           configurat6_.segmentation_id AS segmenta2_1_5_,
           options7_.key AS key1_6_6_,
           ...
      FROM category AS category0_
INNER JOIN segmentation_category AS segmentati1_ ON category0_.id = segmentati1_.category_id
INNER JOIN segmentation AS segmentati2_ ON segmentati1_.segmentation_id = segmentati2_.id
INNER JOIN input_type AS inputtype3_ ON segmentati2_.input_type_id = inputtype3_.id
 LEFT JOIN segmentation_operator AS operators4_ ON segmentati2_.id = operators4_.segmentation_id
 LEFT JOIN operator AS operator5_ ON operators4_.operator_id = operator5_.id
 LEFT JOIN configuration AS configurat6_ ON segmentati2_.id = configurat6_.segmentation_id
 LEFT JOIN option AS options7_ ON segmentati2_.id = options7_.segmentation_id
 LEFT JOIN context AS context8_ ON segmentati2_.context_id = context8_.id
 LEFT JOIN permission AS permission9_ ON segmentati2_.id = permission9_.segmentation_id AND permission9_.mnemonic = '?'
 LEFT JOIN feature AS feature10_ ON segmentati2_.feature_id = feature10_.id
     WHERE category0_.active = true
       AND segmentati2_.active = true
       AND (permission9_.mnemonic IS NULL AND permission9_.segmentation_id IS NULL AND segmentati2_.limited = false OR permission9_.authorized = true)
       AND (feature10_.id IS NULL OR feature10_.active = true AND feature10_.key IN ('?', '?', '?', '?', '?', '?', '?', '?'))
  ORDER BY category0_.ordinality, options7_.display;

  SELECT DISTINCT
         category0_.id AS id1_0_0_,
         segmentati1_.category_id AS category1_9_1_,
         segmentati1_.segmentation_id AS segmenta2_9_1_,
         segmentati2_.id AS id1_8_2_,
         inputtype3_.id AS id1_4_3_,
         operator5_.id AS id1_5_4_,
         configurat6_.key AS key1_1_5_,
         configurat6_.segmentation_id AS segmenta2_1_5_,
         options7_.key AS key1_6_6_,
         options7_.segmentation_id AS segmenta2_6_6_,
         context8_.id AS id1_2_7_,
         category0_.created_on AS created_2_0_0_,
         category0_.updated_on AS updated_3_0_0_,
         category0_.active AS active4_0_0_,
         category0_.description AS descript5_0_0_,
         category0_.display AS display6_0_0_,
         category0_.key AS key7_0_0_,
         category0_.ordinality AS ordinali8_0_0_,
         segmentati1_.created_on AS created_3_9_1_,
         segmentati1_.updated_on AS updated_4_9_1_,
         segmentati1_.ordinality AS ordinali5_9_1_,
         segmentati1_.category_id AS category1_9_0__,
         segmentati1_.segmentation_id AS segmenta2_9_0__,
         segmentati1_.ordinality AS ordinali5_0__,
         segmentati2_.created_on AS created_2_8_2_,
         segmentati2_.updated_on AS updated_3_8_2_,
         segmentati2_.active AS active4_8_2_,
         segmentati2_.attribute AS attribut5_8_2_,
         segmentati2_.context_id AS context12_8_2_,
         segmentati2_.description AS descript6_8_2_,
         segmentati2_.display AS display7_8_2_,
         segmentati2_.feature_id AS feature13_8_2_,
         segmentati2_.input_type_id AS input_t14_8_2_,
         segmentati2_.key AS key8_8_2_,
         segmentati2_.limited AS limited9_8_2_,
         segmentati2_.options_src AS options10_8_2_,
         segmentati2_.title AS title11_8_2_,
         inputtype3_.created_on AS created_2_4_3_,
         inputtype3_.updated_on AS updated_3_4_3_,
         inputtype3_.active AS active4_4_3_,
         inputtype3_.json_value AS json_val5_4_3_,
         inputtype3_.name AS name6_4_3_,
         operator5_.created_on AS created_2_5_4_,
         operator5_.updated_on AS updated_3_5_4_,
         operator5_.display AS display4_5_4_,
         operator5_.key AS key5_5_4_,
         operators4_.segmentation_id AS segmenta1_10_1__,
         operators4_.operator_id AS operator2_10_1__,
         configurat6_.created_on AS created_3_1_5_,
         configurat6_.updated_on AS updated_4_1_5_,
         configurat6_.bool_value AS bool_val5_1_5_,
         configurat6_.string_value AS string_v6_1_5_,
         configurat6_.segmentation_id AS segmenta2_1_2__,
         configurat6_.key AS key1_1_2__,
         options7_.created_on AS created_3_6_6_,
         options7_.updated_on AS updated_4_6_6_,
         options7_.display AS display5_6_6_,
         options7_.segmentation_id AS segmenta2_6_3__,
         options7_.key AS key1_6_3__,
         context8_.created_on AS created_2_2_7_,
         context8_.updated_on AS updated_3_2_7_,
         context8_.key AS key4_2_7_
    FROM category AS category0_
         INNER JOIN segmentation_category AS segmentati1_ ON category0_.id = segmentati1_.category_id
         INNER JOIN segmentation AS segmentati2_ ON segmentati1_.segmentation_id = segmentati2_.id
         INNER JOIN input_type AS inputtype3_ ON segmentati2_.input_type_id = inputtype3_.id
         LEFT JOIN segmentation_operator AS operators4_ ON segmentati2_.id = operators4_.segmentation_id
         LEFT JOIN operator AS operator5_ ON operators4_.operator_id = operator5_.id
         LEFT JOIN configuration AS configurat6_ ON segmentati2_.id = configurat6_.segmentation_id
         LEFT JOIN option AS options7_ ON segmentati2_.id = options7_.segmentation_id
         LEFT JOIN context AS context8_ ON segmentati2_.context_id = context8_.id
         LEFT JOIN permission AS permission9_ ON segmentati2_.id = permission9_.segmentation_id AND permission9_.mnemonic = '?'
         LEFT JOIN feature AS feature10_ ON segmentati2_.feature_id = feature10_.id
   WHERE category0_.active = true
     AND segmentati2_.active = true
     AND (permission9_.mnemonic IS NULL AND permission9_.segmentation_id IS NULL AND segmentati2_.limited = false OR permission9_.authorized = true)
     AND (feature10_.id IS NULL OR feature10_.active = true AND feature10_.key IN ('?', '?', '?', '?', '?', '?', '?', '?'))
ORDER BY category0_.ordinality, options7_.display;

SELECT * FROM pg_catalog.pg_foreign_table WHERE ftrelid = ?;

SELECT
  this_.studentid AS studenti1_26_0_,
  this_.name AS name2_26_0_,
  this_.address_city AS address_3_26_0_,
  this_.address_state AS address_4_26_0_,
  this_.preferredcoursecode AS preferre5_26_0_
FROM
  student AS this_
WHERE
  EXISTS(
    SELECT
      enrolment_.studentid AS y0_
    FROM
      enrolment AS enrolment_
    WHERE
      enrolment_.year
      = (
          SELECT
            max(maxstudentenrolment_.year) AS y0_
          FROM
            enrolment AS maxstudentenrolment_
          WHERE
            this_.preferredcoursecode = maxstudentenrolment_.coursecode
        )
  );

SELECT
	this_.person_id AS person_i1_2_0_,
	this_.version AS version2_2_0_,
	this_.name AS name3_2_0_,
	this_.sex AS sex4_2_0_,
	this_.height_centimeters / 2.54E0 AS height_c5_2_0_,
	this_.address AS address6_2_0_,
	this_.zip AS zip7_2_0_,
	this_.country AS country8_2_0_,
	this_1_.title AS title2_0_0_,
	this_1_.salary AS salary3_0_0_,
	this_1_.pwd_expiry_weeks * 7.0E0 AS pwd_expi4_0_0_,
	this_1_.manager AS manager5_0_0_,
	this_2_.comments AS comments2_1_0_,
	this_2_.salesperson AS salesper3_1_0_
FROM A as this_;

SELECT this_.person_id AS person_i1_2_0_
      ,this_.version AS version2_2_0_,
      ,this_.name AS name3_2_0_,
      ,this_.sex AS sex4_2_0_
      ,this_.height_centimeters / 2.54E0 AS height_c5_2_0_
      ,this_.address AS address6_2_0_
      ,this_.zip AS zip7_2_0_
      ,this_.country AS country8_2_0_
      ,this_1_.title AS title2_0_0_
      ,this_1_.salary AS salary3_0_0_
      ,this_1_.pwd_expiry_weeks * 7.0E0 AS pwd_expi4_0_0_
      ,this_1_.manager AS manager5_0_0_
      ,this_2_.comments AS comments2_1_0_
      ,this_2_.salesperson AS salesper3_1_0_
FROM A as this_;

SELECT array_to_string(array_agg(sql), e'\\n\\n') AS sql 
FROM (
    SELECT (
             (
               (
                 (
                   (
                     (
                       (
                         (
                           (
                             (
                               (
                                 (
                                   (
                                     (
                                       (
                                         (
                                           (
                                             (
                                               (
                                                 (
                                                   (
                                                     CASE WHEN rolcanlogin 
                                                       THEN '-- User: ' 
                                                       ELSE '-- Role: ' 
                                                     END || quote_ident(rolname)
                                                   ) || e'\\n-- DROP '
                                                 ) || CASE WHEN rolcanlogin 
                                                        THEN 'USER ' 
                                                        ELSE 'ROLE ' 
                                                      END
                                               ) || quote_ident(rolname)
                                             ) || e';\\n\\nCREATE '
                                           ) || CASE WHEN rolcanlogin 
                                                  THEN 'USER ' 
                                                  ELSE 'ROLE ' 
                                                END
                                         ) || quote_ident(rolname)
                                       ) || e' WITH\\n  '
                                     ) || CASE WHEN rolcanlogin 
                                            THEN 'LOGIN' 
                                            ELSE 'NOLOGIN' 
                                          END
                                   ) || e'\\n  '
                                 ) || CASE WHEN rolcanlogin AND (rolpassword LIKE 'md5%') 
                                        THEN ('ENCRYPTED PASSWORD ' || quote_literal(rolpassword)) || e'\\n  ' 
                                        ELSE '' 
                                      END
                               ) || CASE WHEN rolsuper 
                                      THEN 'SUPERUSER' 
                                      ELSE 'NOSUPERUSER' 
                                    END
                             ) || e'\\n  '
                           ) || CASE WHEN rolinherit 
                                  THEN 'INHERIT' 
                                  ELSE 'NOINHERIT' 
                                END
                         ) || e'\\n  '
                       ) || CASE WHEN rolcreatedb 
                              THEN 'CREATEDB' 
                              ELSE 'NOCREATEDB' 
                            END
                     ) || e'\\n  '
                   ) || CASE WHEN rolcreaterole 
                          THEN 'CREATEROLE' 
                          ELSE 'NOCREATEROLE' 
                        END
                 ) || e'\\n  '
               ) || CASE WHEN rolreplication 
                      THEN 'REPLICATION' 
                      ELSE 'NOREPLICATION' 
                    END
             ) || CASE WHEN rolconnlimit > 0 
                    THEN e'\\n  CONNECTION LIMIT ' || rolconnlimit 
                    ELSE '' 
                  END
           ) || CASE WHEN rolvaliduntil IS NOT NULL 
                  THEN e'\\n  VALID UNTIL ' || quote_literal(rolvaliduntil::TEXT) 
                  ELSE ';' 
           END AS sql 
    FROM pg_roles AS r 
    WHERE r.oid = 823966177::OID 
  UNION ALL 
    (
      SELECT array_to_string(array_agg(sql), e'\\n') AS sql 
      FROM (
        SELECT (
                 (
                   (
                     'GRANT ' || array_to_string(array_agg(rolname), ', ')
                   ) || ' TO '
                 ) || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))
               ) || CASE WHEN admin_option 
                      THEN ' WITH ADMIN OPTION;' 
                      ELSE ';' 
                    END AS sql 
        FROM (
          SELECT quote_ident(r.rolname) AS rolname, 
                 m.admin_option AS admin_option 
          FROM pg_auth_members AS m 
          LEFT JOIN pg_roles AS r 
            ON (m.roleid = r.oid) 
          WHERE m.member = 823966177::OID 
          ORDER BY r.rolname
        ) AS a 
        GROUP BY admin_option
      ) AS s
    ) 
  UNION ALL 
    (
      SELECT array_to_string(array_agg(sql), e'\\n') AS sql 
      FROM (
        SELECT (
                 (
                   (
                     (
                       (
                         (
                           'ALTER ' || CASE WHEN rolcanlogin 
                                         THEN 'USER ' 
                                         ELSE 'ROLE ' 
                                       END
                         ) || pg_catalog.quote_ident(rolname)
                       ) || ' SET '
                     ) || param
                   ) || ' TO '
                 ) || CASE WHEN param IN ('search_path', 'temp_tablespaces') 
                        THEN value 
                        ELSE quote_literal(value) 
                     END
                 ) || ';' AS sql 
        FROM (
          SELECT rolcanlogin, 
                 rolname, 
                 split_part(rolconfig, '=', 1) AS param, 
                 replace(rolconfig, split_part(rolconfig, '=', 1) || '=', '') AS value 
          FROM (
            SELECT unnest(rolconfig) AS rolconfig, 
                   rolcanlogin, 
                   rolname 
            FROM pg_catalog.pg_roles 
            WHERE oid = 823966177::OID) AS r
        ) AS a
      ) AS b
    ) 
  UNION ALL 
    (
      SELECT array_to_string(array_agg(sql), e'\\n') AS sql 
      FROM (
        SELECT (
                 (
                   (
                     (
                       (
                         (
                           (
                             'ALTER ROLE ' || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))
                           ) || ' IN DATABASE '
                         ) || pg_catalog.quote_ident(datname)
                       ) || ' SET '
                     ) || param
                   ) || ' TO '
                 ) || CASE WHEN param IN ('search_path', 'temp_tablespaces') 
                        THEN value 
                        ELSE quote_literal(value) 
                     END
               ) || ';' AS sql 
        FROM (
          SELECT datname, 
                 split_part(rolconfig, '=', 1) AS param, 
                 replace(rolconfig, split_part(rolconfig, '=', 1) || '=', '') AS value 
          FROM (
            SELECT d.datname, 
                   unnest(c.setconfig) AS rolconfig 
            FROM (
              SELECT * 
              FROM pg_catalog.pg_db_role_setting AS dr 
              WHERE (dr.setrole = 823966177::OID) 
                AND (dr.setdatabase != 0)
            ) AS c 
            LEFT JOIN pg_catalog.pg_database AS d 
            ON (d.oid = c.setdatabase)
          ) AS a
        ) AS b
      ) AS d
    ) 
  UNION ALL 
    (
      SELECT (
               (
                 (
                   'COMMENT ON ROLE ' || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))
                 ) || ' IS '
               ) || pg_catalog.quote_literal(description)
             ) || ';' AS sql 
      FROM (
        SELECT pg_catalog.shobj_description(823966177::OID, 'pg_authid') AS description
      ) AS a 
      WHERE description IS NOT NULL
    ) 
  UNION ALL 
    (
      SELECT array_to_string(array_agg(sql), e'\\n') AS sql 
      FROM (
        SELECT (
          (
            (
              (
                (
                  'SECURITY LABEL FOR ' || provider
                ) || e'\\n  ON ROLE '
              ) || pg_catalog.quote_ident(rolname)
            ) || e'\\n  IS '
          ) || pg_catalog.quote_literal(label)
        ) || ';' AS sql 
        FROM (
          SELECT label, 
                 provider, 
                 rolname 
          FROM (
            SELECT * 
            FROM pg_shseclabel AS sl1 
            WHERE sl1.objoid = 823966177::OID
          ) AS s 
          LEFT JOIN pg_catalog.pg_roles AS r 
          ON (s.objoid = r.oid)
        ) AS a
      ) AS b
    )
  ) AS a

SELECT array_to_string(array_agg(sql), e'\\n\\n') AS sql
FROM
	(
		SELECT (((((((((((((((((((((CASE WHEN rolcanlogin THEN '-- User: ' ELSE '-- Role: ' END || quote_ident(rolname)) || e'\\n-- DROP ') || CASE WHEN rolcanlogin THEN 'USER ' ELSE 'ROLE ' END) || quote_ident(rolname)) || e';\\n\\nCREATE ') || CASE WHEN rolcanlogin THEN 'USER ' ELSE 'ROLE ' END) || quote_ident(rolname)) || e' WITH\\n  ') || CASE WHEN rolcanlogin THEN 'LOGIN' ELSE 'NOLOGIN' END) || e'\\n  ') || CASE WHEN rolcanlogin AND (rolpassword LIKE 'md5%') THEN ('ENCRYPTED PASSWORD ' || quote_literal(rolpassword)) || e'\\n  ' ELSE '' END) || CASE WHEN rolsuper THEN 'SUPERUSER' ELSE 'NOSUPERUSER' END) || e'\\n  ') || CASE WHEN rolinherit THEN 'INHERIT' ELSE 'NOINHERIT' END) || e'\\n  ') || CASE WHEN rolcreatedb THEN 'CREATEDB' ELSE 'NOCREATEDB' END) || e'\\n  ') || CASE WHEN rolcreaterole THEN 'CREATEROLE' ELSE 'NOCREATEROLE' END) || e'\\n  ') || CASE WHEN rolreplication THEN 'REPLICATION' ELSE 'NOREPLICATION' END) || CASE WHEN rolconnlimit > 0 THEN e'\\n  CONNECTION LIMIT ' || rolconnlimit ELSE '' END) || CASE WHEN rolvaliduntil IS NOT NULL THEN e'\\n  VALID UNTIL ' || quote_literal(rolvaliduntil::TEXT) ELSE ';' END AS sql FROM pg_roles AS r WHERE r.oid = 823966177::OID UNION ALL (SELECT array_to_string(array_agg(sql), e'\\n') AS sql FROM (SELECT ((('GRANT ' || array_to_string(array_agg(rolname), ', ')) || ' TO ') || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))) || CASE WHEN admin_option THEN ' WITH ADMIN OPTION;' ELSE ';' END AS sql FROM (SELECT quote_ident(r.rolname) AS rolname, m.admin_option AS admin_option FROM pg_auth_members AS m LEFT JOIN pg_roles AS r ON (m.roleid = r.oid) WHERE m.member = 823966177::OID ORDER BY r.rolname) AS a GROUP BY admin_option) AS s) UNION ALL (SELECT array_to_string(array_agg(sql), e'\\n') AS sql FROM (SELECT (((((('ALTER ' || CASE WHEN rolcanlogin THEN 'USER ' ELSE 'ROLE ' END) || pg_catalog.quote_ident(rolname)) || ' SET ') || param) || ' TO ') || CASE WHEN param IN ('search_path', 'temp_tablespaces') THEN value ELSE quote_literal(value) END) || ';' AS sql FROM (SELECT rolcanlogin, rolname, split_part(rolconfig, '=', 1) AS param, replace(rolconfig, split_part(rolconfig, '=', 1) || '=', '') AS value FROM (SELECT unnest(rolconfig) AS rolconfig, rolcanlogin, rolname FROM pg_catalog.pg_roles WHERE oid = 823966177::OID) AS r) AS a) AS b) UNION ALL (SELECT array_to_string(array_agg(sql), e'\\n') AS sql FROM (SELECT ((((((('ALTER ROLE ' || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))) || ' IN DATABASE ') || pg_catalog.quote_ident(datname)) || ' SET ') || param) || ' TO ') || CASE WHEN param IN ('search_path', 'temp_tablespaces') THEN value ELSE quote_literal(value) END) || ';' AS sql FROM (SELECT datname, split_part(rolconfig, '=', 1) AS param, replace(rolconfig, split_part(rolconfig, '=', 1) || '=', '') AS value FROM (SELECT d.datname, unnest(c.setconfig) AS rolconfig FROM (SELECT * FROM pg_catalog.pg_db_role_setting AS dr WHERE (dr.setrole = 823966177::OID) AND (dr.setdatabase != 0)) AS c LEFT JOIN pg_catalog.pg_database AS d ON (d.oid = c.setdatabase)) AS a) AS b) AS d) UNION ALL (SELECT ((('COMMENT ON ROLE ' || pg_catalog.quote_ident(pg_get_userbyid(823966177::OID))) || ' IS ') || pg_catalog.quote_literal(description)) || ';' AS sql FROM (SELECT pg_catalog.shobj_description(823966177::OID, 'pg_authid') AS description) AS a WHERE description IS NOT NULL) UNION ALL (SELECT array_to_string(array_agg(sql), e'\\n') AS sql FROM (SELECT ((((('SECURITY LABEL FOR ' || provider) || e'\\n  ON ROLE ') || pg_catalog.quote_ident(rolname)) || e'\\n  IS ') || pg_catalog.quote_literal(label)) || ';' AS sql FROM (SELECT label, provider, rolname FROM (SELECT * FROM pg_shseclabel AS sl1 WHERE sl1.objoid = 823966177::OID) AS s LEFT JOIN pg_catalog.pg_roles AS r ON (s.objoid = r.oid)) AS a) AS b)
	)
		AS a;

CREATE TABLE t (
  created_at TIMESTAMP DEFAULT current_timestamp NOT NULL
);

CREATE TABLE t (
	created_at TIMESTAMP
	           DEFAULT current_timestamp()
	           NOT NULL
);

SELECT
	this_.person_id AS person_i1_2_0_,
	this_.version AS version2_2_0_,
	this_.name AS name3_2_0_,
	this_.sex AS sex4_2_0_,
	this_.height_centimeters / 2.54E0 AS height_c5_2_0_,
	this_.address AS address6_2_0_,
	this_.zip AS zip7_2_0_,
	this_.country AS country8_2_0_,
	this_1_.title AS title2_0_0_,
	this_1_.salary AS salary3_0_0_,
	this_1_.pwd_expiry_weeks * 7.0E0 AS pwd_expi4_0_0_,
	this_1_.manager AS manager5_0_0_,
	this_2_.comments AS comments2_1_0_,
	this_2_.salesperson AS salesper3_1_0_,
	CASE WHEN this_1_.person_id IS NOT NULL THEN 1 WHEN this_2_.person_id IS NOT NULL THEN 2 WHEN this_.person_id IS NOT NULL THEN 0 END
		AS clazz_0_
FROM
	jperson AS this_ LEFT JOIN jemployee AS this_1_ ON this_.person_id = this_1_.person_id
		LEFT JOIN jmanager AS this_2_ ON this_.person_id = this_2_.person_id
WHERE (this_.address, this_.zip, this_.country) IN (($1, $2, $3), ($4, $5, $6));