Duplicate a custom LU

Duplicate every custom field (with only persistant fields) :

INSERT INTO custom_field_attributes_tab 
(
    lu,
    lu_type,
    attribute_name,
    data_type,
    format,
    data_length,
    default_value_type,
    default_value,
    mandatory,
    insertable,
    updateable,
    queryable,
    lov,
    indexed,
    private,
    alternate_key,
    published,
    used,
    enabled_on_reports,
    index_name,
    prompt,
    custom_field_type,
    custom_field_impl_type,
    expression,
    read_only_expression,
    metadata,
    constraint_type,
    lov_view,
    lu_reference,
    ui_object,
    note,
    definition_modified_date,
    rowversion
)
SELECT     
    'new LU name' as LU,
    lu_type,
    attribute_name,
    data_type,
    format,
    data_length,
    default_value_type,
    default_value,
    mandatory,
    insertable,
    updateable,
    queryable,
    lov,
    indexed,
    private,
    alternate_key,
    published,
    used,
    enabled_on_reports,
    index_name,
    prompt,
    custom_field_type,
    custom_field_impl_type,
    replace(expression, 'string to replace', 'new string value') as expression,
    read_only_expression,
    metadata,
    constraint_type,
    lov_view,
    lu_reference,
    ui_object,
    'new note' as note,
    definition_modified_date,
    rowversion
FROM custom_field_attributes_tab
where lu='lu name as reference'
AND CUSTOM_FIELD_TYPE='PERSISTENT_FIELD'

I didn’t test yet to duplicate read only CF, but I would import such fields right after every persistant CF got imported in first, and proceed step by step (like import in first read only CF which only use persistant fields, before importing read only CF which use other read only CF from the same datatable, ect).

I manually created the new LU as it wasn’t a big task .