Constraints Issues with Oracle

### Things to check first

- [X] I have searched the existing issues and didn't find my bug already reported there

- [X] I have checked that my bug is still present in the latest release

### Sqlacodegen version

master

### SQLAlchemy version

2 latest

### RDBMS vendor

Oracle

### What happened?

on writing out contraints, issues occured with capitals, and also spaces in regards to the column name when writing out.


### Database schema for reproducing the bug

CREATE TABLE "QCTL"."COMPANIES"
( "CMP_AUTO_KEY" NUMBER NOT NULL ENABLE,
"CUR_AUTO_KEY" NUMBER,
"SVC_AUTO_KEY" NUMBER,
"TMC_AUTO_KEY" NUMBER,
"TXT_AUTO_KEY" NUMBER,
"CLC_AUTO_KEY" NUMBER,
"FPC_AUTO_KEY" NUMBER,
"COMPANY_CODE" VARCHAR2(10 BYTE) NOT NULL ENABLE,
"SITE_CODE" VARCHAR2(10 BYTE),
"ATTENTION" VARCHAR2(35 BYTE),
"ADDRESS1" VARCHAR2(35 BYTE),
"ADDRESS2" VARCHAR2(35 BYTE),
"ADDRESS3" VARCHAR2(35 BYTE),
"ALT_PHONE_NUMBER" VARCHAR2(20 BYTE),
"CITY" VARCHAR2(35 BYTE),
"COMPANY_ABBREV" VARCHAR2(12 BYTE) NOT NULL ENABLE,
"COMPANY_NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"CONTACT_NAME" VARCHAR2(50 BYTE),
"COUNTRY" VARCHAR2(35 BYTE),
"CURRENT_BALANCE" NUMBER,
"COMPANY_BRIDGE_DATE" DATE,
"CUSTOMER_FLAG" CHAR(1 BYTE),
"DEPARTMENT" VARCHAR2(35 BYTE),
"DISCOUNT" NUMBER,
"FAX_NUMBER" VARCHAR2(20 BYTE),
"FAX_BROADCAST_FLAG" CHAR(1 BYTE),
"INVC_DOC_STYLE" VARCHAR2(15 BYTE),
"LAST_SALE_DATE" DATE,
"MAIL_MERGE_FLAG" CHAR(1 BYTE),
"MAX_CREDIT" NUMBER,
"MISCELLANEOUS" VARCHAR2(20 BYTE),
"NOTES" CLOB DEFAULT empty_clob(),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"PHONE_STRIPPED" VARCHAR2(20 BYTE),
"PO_DOC_STYLE" VARCHAR2(15 BYTE),
"RESALE_NUMBER" VARCHAR2(20 BYTE),
"SHIP_COUNTRY" VARCHAR2(35 BYTE),
"SHIP_CITY" VARCHAR2(35 BYTE),
"SHIP_STATE" VARCHAR2(3 BYTE),
"SHIP_ADDRESS1" VARCHAR2(35 BYTE),
"SHIP_ADDRESS2" VARCHAR2(35 BYTE),
"SHIP_ADDRESS3" VARCHAR2(35 BYTE),
"SHIP_ZIP_CODE" VARCHAR2(10 BYTE),
"STATE" VARCHAR2(3 BYTE),
"SUPPLIER_ID" VARCHAR2(8 BYTE),
"VENDOR_FLAG" CHAR(1 BYTE),
"VENDOR_BRIDGE_DATE" DATE,
"YTD_SALES" NUMBER,
"ZIP_CODE" VARCHAR2(10 BYTE),
"CV_UDF_001" CHAR(1 BYTE),
"CV_UDF_002" CHAR(1 BYTE),
"CV_UDF_003" CHAR(1 BYTE),
"CV_UDF_004" CHAR(1 BYTE),
"CV_UDF_005" CHAR(1 BYTE),
"CV_UDF_006" CHAR(1 BYTE),
"CV_UDF_007" CHAR(1 BYTE),
"CV_UDF_008" CHAR(1 BYTE),
"CV_UDF_009" CHAR(1 BYTE),
"CV_UDF_010" CHAR(1 BYTE),
"CV_UDF_011" VARCHAR2(40 BYTE),
"CV_UDF_012" VARCHAR2(40 BYTE),
"CV_UDF_013" VARCHAR2(40 BYTE),
"CV_UDF_014" VARCHAR2(40 BYTE),
"CV_UDF_015" VARCHAR2(40 BYTE),
"COMPANY_NAME_UPPER" VARCHAR2(50 BYTE),
"COMPANY_CODE_UPPER" VARCHAR2(10 BYTE),
"SITE_CODE_UPPER" VARCHAR2(10 BYTE),
"TAX_ID" VARCHAR2(35 BYTE),
"VAT_NUMBER" VARCHAR2(25 BYTE),
"SEND_1099" CHAR(1 BYTE),
"GLA_AR" NUMBER,
"GLA_AP" NUMBER,
"EMAIL_ADDRESS" VARCHAR2(255 BYTE),
"IQ_ENABLE_QTY" CHAR(1 BYTE),
"IQ_ENABLE_PRICE" CHAR(1 BYTE),
"IQ_ENABLE_CONDITION" CHAR(1 BYTE),
"IQ_ENABLE_STOCK" CHAR(1 BYTE),
"IQ_ENABLE_TIMELIFE" CHAR(1 BYTE),
"IQ_ENABLE_RFQ" CHAR(1 BYTE),
"IQ_ENABLE_PO" CHAR(1 BYTE),
"SYSUR_IQ_NOTIFY_RFQ" NUMBER,
"SYSUR_IQ_NOTIFY_PO" NUMBER,
"ALLOW_ANY" VARCHAR2(10 BYTE),
"ALLOW_CQ" VARCHAR2(10 BYTE),
"ALLOW_VQ" VARCHAR2(10 BYTE),
"ALLOW_PO" VARCHAR2(10 BYTE),
"ALLOW_SO" VARCHAR2(10 BYTE),
"ALLOW_IN" VARCHAR2(10 BYTE),
"ALLOW_RO" VARCHAR2(10 BYTE),
"IQ_LOC" NUMBER,
"IQ_USER" VARCHAR2(30 BYTE),
"IQ_PASS" VARCHAR2(30 BYTE),
"IQ_RESPONSE_EMAIL" VARCHAR2(60 BYTE),
"IQ_HOSTNAME_OVERRIDE" VARCHAR2(100 BYTE),
"IQ_SEQ" NUMBER DEFAULT 1,
"IQ_CURRENCY" VARCHAR2(50 BYTE),
"AGN_AUTO_KEY" NUMBER,
"SPN_AUTO_KEY" NUMBER,
"FAX_STRIPPED" VARCHAR2(20 BYTE),
"DEFERRED_REC" CHAR(1 BYTE) DEFAULT 'F',
"SPEC_2000" CHAR(1 BYTE) DEFAULT 'F',
"CAP_RESTRICT_LEVEL" VARCHAR2(8 BYTE) DEFAULT 'NONE',
"AP_TOTAL" NUMBER(19,4) DEFAULT 0,
"IQ_VIEW_RFQ" CHAR(1 BYTE),
"IQ_VIEW_PO" CHAR(1 BYTE),
"IQ_QUOTE_TO_PO" CHAR(1 BYTE),
"CONVERTED" CHAR(1 BYTE) DEFAULT 'F',
"ILS_CODE" VARCHAR2(4 BYTE),
"CV_UDF_016" VARCHAR2(40 BYTE),
"CV_UDF_017" VARCHAR2(40 BYTE),
"CV_UDF_018" VARCHAR2(40 BYTE),
"CV_UDF_019" VARCHAR2(40 BYTE),
"CV_UDF_020" VARCHAR2(255 BYTE),
"CV_UDF_021" VARCHAR2(50 BYTE),
"CV_UDF_022" VARCHAR2(50 BYTE),
"CV_UDF_023" VARCHAR2(50 BYTE),
"CV_UDF_024" VARCHAR2(50 BYTE),
"CV_UDF_025" VARCHAR2(50 BYTE),
"CQ_WARNING" CLOB DEFAULT empty_clob(),
"SO_WARNING" CLOB DEFAULT empty_clob(),
"IN_WARNING" CLOB DEFAULT empty_clob(),
"VQ_WARNING" CLOB DEFAULT empty_clob(),
"PO_WARNING" CLOB DEFAULT empty_clob(),
"RO_WARNING" CLOB DEFAULT empty_clob(),
"WO_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WO" VARCHAR2(10 BYTE),
"QUANTUM_ID" NUMBER,
"ALLOW_CM" VARCHAR2(10 BYTE),
"CM_WARNING" CLOB DEFAULT empty_clob(),
"TMC_VEND_OVERRIDE" NUMBER,
"EB_USERID" VARCHAR2(40 BYTE),
"DBA" CHAR(1 BYTE) DEFAULT 'F',
"CMP_PARENT" NUMBER,
"MKT_COMPANY_CODE" VARCHAR2(10 BYTE),
"MKC_AUTO_KEY" NUMBER,
"CV_UDF_053" DATE,
"DEFERRED_RO_REC" CHAR(1 BYTE),
"USE_MKT" CHAR(1 BYTE) DEFAULT 'F',
"RESTRICTED" CHAR(1 BYTE) DEFAULT 'F',
"SYSUR_AUTO_KEY" NUMBER,
"DATE_CREATED" DATE,
"PRIORITY_VENDOR" CHAR(1 BYTE) DEFAULT 'F',
"CREDIT_LIMIT" NUMBER(19,4) DEFAULT 0,
"QB_CUST_LISTID" VARCHAR2(40 BYTE),
"QB_VEND_LISTID" VARCHAR2(40 BYTE),
"SDF_CMP_001" VARCHAR2(40 BYTE),
"SDF_CMP_002" VARCHAR2(40 BYTE),
"SDF_CMP_003" VARCHAR2(40 BYTE),
"SDF_CMP_004" VARCHAR2(40 BYTE),
"SDF_CMP_005" VARCHAR2(40 BYTE),
"SDF_CMP_006" VARCHAR2(40 BYTE),
"SDF_CMP_007" VARCHAR2(40 BYTE),
"SDF_CMP_008" VARCHAR2(40 BYTE),
"SDF_CMP_009" VARCHAR2(40 BYTE),
"SDF_CMP_010" VARCHAR2(40 BYTE),
"ELC_REQUIRED" CHAR(1 BYTE) DEFAULT 'F',
"LABOR_DISCOUNT" NUMBER(19,4),
"CV_UDF_054" DATE,
"CNC_AUTO_KEY" NUMBER,
"ALLOW_WC" VARCHAR2(10 BYTE),
"WC_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WQ" VARCHAR2(10 BYTE),
"WQ_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WQ_BILL" VARCHAR2(10 BYTE),
"WQ_BILL_WARNING" CLOB DEFAULT empty_clob(),
"CORE_DUE_DAYS" NUMBER,
"DEPT_COMPANY" CHAR(1 BYTE) DEFAULT 'F',
"REQ_VERIFICATION" CHAR(1 BYTE) DEFAULT 'F',
"TRACK_CHANGES" CHAR(1 BYTE) DEFAULT 'F',
"GLD_AR" NUMBER,
"GLD_AP" NUMBER,
"COC_AUTO_KEY" NUMBER,
"SHIP_NAME" VARCHAR2(50 BYTE),
"DTC_AUTO_KEY" NUMBER,
"LAST_MODIFIED" DATE,
"SYSUR_MODIFIED" NUMBER,
"GLD_AP_PREPAY" NUMBER,
"GLD_AR_PREPAY" NUMBER,
"EDI_NUMBER" VARCHAR2(30 BYTE),
"EDI_SEQUENCE" NUMBER,
"LANG_CODE" VARCHAR2(2 BYTE) DEFAULT 'GB',
"ENQUEUE_MSG" CHAR(1 BYTE),
"ROUTING_NUMBER" VARCHAR2(15 BYTE),
"ACCOUNT_NUMBER" VARCHAR2(35 BYTE),
"ACH_VENDOR" VARCHAR2(1 BYTE) DEFAULT 'F',
"GLD_AP_EXPENSE" NUMBER,
"WEB_SITE" VARCHAR2(100 BYTE),
"INVOICE_EMAIL" VARCHAR2(60 BYTE),
"GLD_AP_SUSPENSE" NUMBER,
"INTERNAL_FLAG" VARCHAR2(1 BYTE) DEFAULT 'F',
"COC_OFFICE" NUMBER,
"APPROVAL_EXPIRE" DATE,
"APR_AUTO_KEY" NUMBER,
"CONVERSION_ID" NUMBER,
"DHL_DELIVERY_DUTY_PAYOR" VARCHAR2(15 BYTE) DEFAULT 'DDU',
"ALLOW_WP" VARCHAR2(10 BYTE),
"WP_WARNING" CLOB DEFAULT empty_clob(),
"VQ_APPROVED" VARCHAR2(1 BYTE) DEFAULT 'F',
"CFF_AUTO_KEY" NUMBER,
"BANK_NAME" VARCHAR2(70 BYTE),
"BANK_ADDRESS1" VARCHAR2(35 BYTE),
"BANK_ADDRESS2" VARCHAR2(35 BYTE),
"BANK_ADDRESS3" VARCHAR2(35 BYTE),
"BANK_COUNTRY_CODE" VARCHAR2(3 BYTE),
"INTERMEDIATE_BANK_NAME" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDRESS1" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDRESS2" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDDRES3" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_COUNTRY" VARCHAR2(3 BYTE),
"INTERMEDIATE_BANK_SWIFT" VARCHAR2(11 BYTE),
"INTERMEDIATE_CLEARING_CODE" VARCHAR2(30 BYTE),
"INTERMEDIATE_CLEARING_TYPE" VARCHAR2(35 BYTE),
"SWIFT_CODE" VARCHAR2(11 BYTE),
"ALLOW_MO" VARCHAR2(10 BYTE),
"MO_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_PR" VARCHAR2(10 BYTE),
"PR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_LC" VARCHAR2(10 BYTE),
"LC_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_AP" VARCHAR2(10 BYTE),
"AP_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_CR" VARCHAR2(10 BYTE),
"CR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_RR" VARCHAR2(10 BYTE),
"RR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_CKM" VARCHAR2(10 BYTE),
"CKM_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_SMB" VARCHAR2(10 BYTE),
"SMB_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_SM" VARCHAR2(10 BYTE),
"SM_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_RI" VARCHAR2(10 BYTE),
"RI_WARNING" CLOB DEFAULT empty_clob(),
"SDF_CMP_011" VARCHAR2(40 BYTE),
"SDF_CMP_012" VARCHAR2(40 BYTE),
"SDF_CMP_013" VARCHAR2(40 BYTE),
"SDF_CMP_014" VARCHAR2(40 BYTE),
"SDF_CMP_015" VARCHAR2(40 BYTE),
"SDF_CMP_016" VARCHAR2(40 BYTE),
"SDF_CMP_017" VARCHAR2(40 BYTE),
"SDF_CMP_018" VARCHAR2(40 BYTE),
"SDF_CMP_019" VARCHAR2(40 BYTE),
"SDF_CMP_020" VARCHAR2(40 BYTE),
"RECO" VARCHAR2(1 BYTE) DEFAULT 'F',
"EDD_ID" VARCHAR2(50 BYTE),
"SMA_WARNING" CLOB DEFAULT empty_clob(),
"BOX_1099" NUMBER DEFAULT 7,
"REQ_CONTRACT" VARCHAR2(1 BYTE) DEFAULT 'F',
"BANK_CHARGES_INDICATOR" NUMBER DEFAULT 0,
"PO_COST_METHOD" CHAR(1 BYTE) DEFAULT '0',
"BUC_CODE" VARCHAR2(20 BYTE),
"WO_NOTES" CLOB DEFAULT empty_clob(),
"MSG_VENDOR" CHAR(1 BYTE) DEFAULT 'F',
"AMAZON_BUCKET" VARCHAR2(256 BYTE),
"QQM_SENDER_ID" VARCHAR2(10 BYTE),
"MFG_AUTO_KEY" NUMBER,
"INTEGRATED_MANUALS" VARCHAR2(1 BYTE),
"SDF_CMP_021" VARCHAR2(40 BYTE),
"TRACKER_VISIBLE_PORTAL" VARCHAR2(1 BYTE),
"BOA_WARNING" CLOB DEFAULT empty_clob(),
"PBH_FLAG" VARCHAR2(1 BYTE),
"ALLOW_SMS" VARCHAR2(10 BYTE) DEFAULT 'Yes',
"SMS_WARNING" CLOB DEFAULT empty_clob(),
"PMA_RESTRICTED" VARCHAR2(1 BYTE) DEFAULT 'F',
"IBAN_ACCOUNT_NUMBER" VARCHAR2(35 BYTE),
"DER_RESTRICTED" VARCHAR2(1 BYTE) DEFAULT 'F',
"HISTORICAL" VARCHAR2(1 BYTE) DEFAULT 'F',
"ALLOW_CERT" VARCHAR2(10 BYTE),
"CERT_WARNING" CLOB DEFAULT empty_clob(),
"STOCK_SAFETY_PRIORITY_LEVEL" NUMBER,
"FOB" VARCHAR2(30 BYTE),
"SYSCM_AUTO_KEY" NUMBER,
"AEX_REGISTRATION_ID" VARCHAR2(10 BYTE),
"QQM_IMS_AUTO_KEY" NUMBER,
"ALLOW_RC" VARCHAR2(10 BYTE),
"RC_WARNING" CLOB DEFAULT empty_clob(),
"CMG_AUTO_KEY" NUMBER,
"EDI_AUTO_DELIVER" VARCHAR2(1 BYTE),
CONSTRAINT "VALID_RULE_21641" CHECK ( SPEC_2000 in ('F','T') ) ENABLE,
CONSTRAINT "VALID_RULE_179" CHECK ( CAP_RESTRICT_LEVEL IN ('NONE', 'WARN', 'RESTRICT') ) ENABLE,
CONSTRAINT "VALID_RULE_21640" CHECK ( DEFERRED_REC in ('F','T') ) ENABLE,
CONSTRAINT "FK_SYSR_CMP" FOREIGN KEY ("SYSUR_AUTO_KEY")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TMC_CMP" FOREIGN KEY ("TMC_AUTO_KEY")
REFERENCES "QCTL"."TERM_CODES" ("TMC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_COC_CMP_OFFICE" FOREIGN KEY ("COC_OFFICE")
REFERENCES "QCTL"."COUNTRY_CODES" ("COC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AR_PREPAY" FOREIGN KEY ("GLD_AR_PREPAY")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TMC_CMP_VEND" FOREIGN KEY ("TMC_VEND_OVERRIDE")
REFERENCES "QCTL"."TERM_CODES" ("TMC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CLC_CMP" FOREIGN KEY ("CLC_AUTO_KEY")
REFERENCES "QCTL"."CLASS_CODES" ("CLC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_COC_CMP" FOREIGN KEY ("COC_AUTO_KEY")
REFERENCES "QCTL"."COUNTRY_CODES" ("COC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_DTC_CMP" FOREIGN KEY ("DTC_AUTO_KEY")
REFERENCES "QCTL"."DELIVERY_TERMS" ("DTC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_MKC_CMP" FOREIGN KEY ("MKC_AUTO_KEY")
REFERENCES "QCTL"."MARKUP_CODES" ("MKC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_SUSPENSE" FOREIGN KEY ("GLD_AP_SUSPENSE")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CUR_CMP" FOREIGN KEY ("CUR_AUTO_KEY")
REFERENCES "QCTL"."CURRENCY" ("CUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TXT_CMP" FOREIGN KEY ("TXT_AUTO_KEY")
REFERENCES "QCTL"."TAX_TABLE" ("TXT_AUTO_KEY") ENABLE,
CONSTRAINT "FK_QQM_IMS_CMP" FOREIGN KEY ("QQM_IMS_AUTO_KEY")
REFERENCES "QCTL"."IMAGE_SERVER" ("IMS_AUTO_KEY") ENABLE,
CONSTRAINT "FK_MFG_CMP" FOREIGN KEY ("MFG_AUTO_KEY")
REFERENCES "QCTL"."MANUFACTURER" ("MFG_AUTO_KEY") ENABLE,
CONSTRAINT "FK_APR_CMP" FOREIGN KEY ("APR_AUTO_KEY")
REFERENCES "QCTL"."APPROVAL_CODES" ("APR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SYSR_CMP_PO" FOREIGN KEY ("SYSUR_IQ_NOTIFY_PO")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_FPC_CMP" FOREIGN KEY ("FPC_AUTO_KEY")
REFERENCES "QCTL"."FAX_PREFIX_CODES" ("FPC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_EXPENSE" FOREIGN KEY ("GLD_AP_EXPENSE")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SVC_CMP" FOREIGN KEY ("SVC_AUTO_KEY")
REFERENCES "QCTL"."SHIP_VIA_CODES" ("SVC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CMG_CMP" FOREIGN KEY ("CMG_AUTO_KEY")
REFERENCES "QCTL"."COMPANY_GROUPS" ("CMG_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SYSR_CMP_RFQ" FOREIGN KEY ("SYSUR_IQ_NOTIFY_RFQ")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_PREPAY" FOREIGN KEY ("GLD_AP_PREPAY")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CFF_CMP" FOREIGN KEY ("CFF_AUTO_KEY")
REFERENCES "QCTL"."CK_FILE_FORMAT_CODES" ("CFF_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CMP_CMP" FOREIGN KEY ("CMP_PARENT")
REFERENCES "QCTL"."COMPANIES" ("CMP_AUTO_KEY") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING