Search Shortcut cmd + k | ctrl + k
inflector
Downloads 645this week
GitHub stars 2
Extension repository on GitHub
Extension descriptor (YAML)

Powerful string case transformation and inflection capabilities directly to your SQL queries.

Maintainer(s): rustyconover

Installing and Loading 

INSTALL inflector FROM community;
LOAD inflector;

About inflector

For more information regarding usage, see the documentation.

Added Functions

function_name function_type description comment examples
inflect scalar Transforms a string value using the specified case format NULL [inflect('snake', 'helloWorld')]
inflect scalar Transforms struct field names using the specified case format NULL [inflect('snake', {firstName: 'John', lastName: 'Doe'})]
inflect table Transforms column names in query results using the specified case format NULL [FROM inflect('snake', SELECT firstName, lastName FROM users)]
inflector_deconstantize scalar Removes the rightmost segment from a constant expression NULL [inflector_deconstantize('Net::HTTP')]
inflector_demodulize scalar Removes the module part from a fully qualified name NULL [inflector_demodulize('ActiveRecord::CoreExtensions::String')]
inflector_deordinalize scalar Removes the ordinal suffix from a string (1st -> 1) NULL [inflector_deordinalize('1st')]
inflector_is_camel_case scalar Returns true if the string is in camelCase format NULL [inflector_is_camel_case('helloWorld')]
inflector_is_class_case scalar Returns true if the string is in ClassCase (PascalCase) format NULL [inflector_is_class_case('HelloWorld')]
inflector_is_foreign_key scalar Returns true if the string is in foreign key format (ends with _id) NULL [inflector_is_foreign_key('message_id')]
inflector_is_kebab_case scalar Returns true if the string is in kebab-case format NULL [inflector_is_kebab_case('hello-world')]
inflector_is_pascal_case scalar Returns true if the string is in PascalCase format NULL [inflector_is_pascal_case('HelloWorld')]
inflector_is_screamingsnake_case scalar Returns true if the string is in SCREAMING_SNAKE_CASE format NULL [inflector_is_screamingsnake_case('HELLO_WORLD')]
inflector_is_sentence_case scalar Returns true if the string is in Sentence case format NULL [inflector_is_sentence_case('Hello world')]
inflector_is_snake_case scalar Returns true if the string is in snake_case format NULL [inflector_is_snake_case('hello_world')]
inflector_is_table_case scalar Returns true if the string is in table_case format (snake_case plural) NULL [inflector_is_table_case('foo_bars')]
inflector_is_title_case scalar Returns true if the string is in Title Case format NULL [inflector_is_title_case('Hello World')]
inflector_is_train_case scalar Returns true if the string is in Train-Case format NULL [inflector_is_train_case('Hello-World')]
inflector_ordinalize scalar Converts a number string to its ordinal form (1st, 2nd, 3rd, etc.) NULL [inflector_ordinalize('1')]
inflector_to_camel_case scalar Converts a string to camelCase format NULL [inflector_to_camel_case('hello_world')]
inflector_to_class_case scalar Converts a string to ClassCase (PascalCase) format NULL [inflector_to_class_case('hello_world')]
inflector_to_foreign_key scalar Converts a class name to a foreign key column name NULL [inflector_to_foreign_key('Message')]
inflector_to_kebab_case scalar Converts a string to kebab-case format NULL [inflector_to_kebab_case('helloWorld')]
inflector_to_pascal_case scalar Converts a string to PascalCase format NULL [inflector_to_pascal_case('hello_world')]
inflector_to_plural scalar Returns the plural form of a word NULL [inflector_to_plural('person')]
inflector_to_screamingsnake_case scalar Converts a string to SCREAMING_SNAKE_CASE format NULL [inflector_to_screamingsnake_case('helloWorld')]
inflector_to_sentence_case scalar Converts a string to Sentence case format NULL [inflector_to_sentence_case('helloWorld')]
inflector_to_singular scalar Returns the singular form of a word NULL [inflector_to_singular('people')]
inflector_to_snake_case scalar Converts a string to snake_case format NULL [inflector_to_snake_case('helloWorld')]
inflector_to_table_case scalar Converts a string to table_cases format (snake_case plural) NULL [inflector_to_table_case('FooBar')]
inflector_to_title_case scalar Converts a string to Title Case format NULL [inflector_to_title_case('hello_world')]
inflector_to_train_case scalar Converts a string to Train-Case format NULL [inflector_to_train_case('helloWorld')]

Added Settings

name description input_type scope aliases
auto_fallback_to_full_download Allows automatically falling back to full file downloads when possible. BOOLEAN GLOBAL []
ca_cert_file Path to a custom certificate file for self-signed certificates. VARCHAR GLOBAL []
enable_curl_server_cert_verification Enable server side certificate verification for CURL backend. BOOLEAN GLOBAL []
enable_server_cert_verification Enable server side certificate verification. BOOLEAN GLOBAL []
force_download Forces upfront download of file BOOLEAN GLOBAL []
hf_max_per_page Debug option to limit number of items returned in list requests UBIGINT GLOBAL []
http_keep_alive Keep alive connections. Setting this to false can help when running into connection failures BOOLEAN GLOBAL []
http_retries HTTP retries on I/O error UBIGINT GLOBAL []
http_retry_backoff Backoff factor for exponentially increasing retry wait time FLOAT GLOBAL []
http_retry_wait_ms Time between retries UBIGINT GLOBAL []
http_timeout HTTP timeout read/write/connection/retry (in seconds) UBIGINT GLOBAL []
httpfs_client_implementation Select which is the HTTPUtil implementation to be used VARCHAR GLOBAL []
merge_http_secret_into_s3_request Merges http secret params into S3 requests BOOLEAN GLOBAL []
s3_access_key_id S3 Access Key ID VARCHAR GLOBAL []
s3_endpoint S3 Endpoint VARCHAR GLOBAL []
s3_kms_key_id S3 KMS Key ID VARCHAR GLOBAL []
s3_region S3 Region VARCHAR GLOBAL []
s3_requester_pays S3 use requester pays mode BOOLEAN GLOBAL []
s3_secret_access_key S3 Access Key VARCHAR GLOBAL []
s3_session_token S3 Session Token VARCHAR GLOBAL []
s3_uploader_max_filesize S3 Uploader max filesize (between 50GB and 5TB) VARCHAR GLOBAL []
s3_uploader_max_parts_per_file S3 Uploader max parts per file (between 1 and 10000) UBIGINT GLOBAL []
s3_uploader_thread_limit S3 Uploader global thread limit UBIGINT GLOBAL []
s3_url_compatibility_mode Disable Globs and Query Parameters on S3 URLs BOOLEAN GLOBAL []
s3_url_style S3 URL style VARCHAR GLOBAL []
s3_use_ssl S3 use SSL BOOLEAN GLOBAL []
unsafe_disable_etag_checks Disable checks on ETag consistency BOOLEAN GLOBAL []